I have a CSV with what I think is an unusual date format:
Mon Nov 14 2016 11:31:26 GMT+0200 (South Africa Standard Time)
I would like to convert that a
DATETIME2 (or other date format) in SQL Server 2016.
Is there an easy way to do this or would I have to do some kind of string manipulation first? I find that if I can shorten the string to
SELECT CONVERT(datetime2, 'Nov 14 2016 17:12:18') then I get a result.