Date Format

[jingamells]

Hi,

I am using the below to try and change a string of dd/mm/yy hh:mm to yyyymmdd and getting the following error: 'Conversion failed when converting date and/or time from character string.'

convert(varchar(8),cast(ArrivalDateTime as date),112) as ArrivalDateTime,

what am i doing wrong?

TIA
James

[Sherin]

insert into table1 values('2012-02-21T18:10:00', '2012-01-01T00:00:00');

SELECT
   CAST('02-21-2012 6:10:00 PM' AS DATETIME2),    
   CAST('01-01-2012 12:00:00 AM' AS DATETIME2) 

You can try this.

Edited September 10, 2020 by Sherin