Declare @date_time_value varchar(100)= '10/1/15 21:02:04' select CONVERT(datetime2, @date_time_value, 3) as UK_Date_Time_Style Figure 4: Correct Date Format with “dd/mm/yy” British/French date style ...