Varchar datetime with EDT in it convert into datetime
I have this nvarchar column to store the datetime values and the values in this format. I need to convert this to a datetime.
How to custom format a number in T-SQL
If you use this custom mask to format a number in MS-SQL, you’ll see that it ignores all but the decimal mask and does it’s own thing (which I believe might have something to do with the regional settings of the SQL server):