Link to home
Create AccountLog in
Avatar of Rick
Rick

asked on

SQL - Convert month name or month number to datetime

Is there a way to convert a month name or month number to datetime in SQL?

Ex:
   Convert 'November' to '2010-11-01 00:00:00.000'       or
   Convert '11' to '2010-11-01 00:00:00.000'
Avatar of Rick
Rick

ASKER

... or Convert 'NOV' to '2010-11-01 00:00:00.000'  
ASKER CERTIFIED SOLUTION
Avatar of ralmada
ralmada
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rick

ASKER

Simple as that!

Thank you, ralmada.