Date Convert Help

[robert030975]

I'm stuggling a bit to convert this into a date time and was wondering if someone could help


'May 17 2010 5:45AM'


Thanks

Robert

 

[gmmastros]

There must be more to it. The format you show works perfectly fine for me.

Select Convert(DateTime, 'May 17 2010 5:45AM')

Can you please elaborate on the problem you are having?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[robert030975]

Simple I forgot the SET DATEFORMAT!! Its great using a Sever thats got the wrong local setup.

Thanks

George