datetime conversion 1

[Chumley40]

I need to convert a varchar field that returns datetime in the format of May-18-09 14:00 into a datetime field. When I do a simple cast (fieldname as datetime) I get an overflow. Does anyone know how to cast or convert this format in sql as a datetime?

Thanks in advance,
TJ

 

[quatermass]

Hi TJ

Try

select convert(datetime, replace('May-18-09 14:00', '-', ' '), 109)

The format 109 wants the format to be
mon dd yyyy hh:mi:ss:mmmAM (or PM)

Using the replace function creates that format.


Hope it helps

Kevin

**************************************************************
Rock is Dead (Long Live Paper and Scissors)
**************************************************************

 

[Chumley40]

Worked like a charm, thanks so much,
TJ