SQL Server 2008 Convert String to Datetime question

Question

I have a string column in a table that display data as "CXL P/D 08/15/13"

I'm trying to convert this column to datetime, but I can't figure out how to extract only date and change the data type.

Cast(RIGHT(RTRIM(Trade_Date) ,8)as datetime) I'm trying this statement but it doesn't work

Conversion failed when converting date and/or time from character string.

Thank you

Mikael Eriksson · Accepted Answer · 2013-09-20 17:27:57Z

6

Use CONVERT and specify 1 as the date time style 1 = mm/dd/yy.

CONVERT(datetime, RIGHT('CXL P/D 08/15/13', 8), 1)

answered Sep 20, 2013 at 17:27

Mikael Eriksson

22.3k5 gold badges63 silver badges106 bronze badges

1 Answer 1