asked on
SQL 2008 - Convert string to date
Good morning,
I have a number of string fields that represent dates. I would like to convert them to date fields like so:
From: 25-JAN-13
To: 01/25/2013
Thanks in advance for any help.
I have a number of string fields that represent dates. I would like to convert them to date fields like so:
From: 25-JAN-13
To: 01/25/2013
Thanks in advance for any help.
Microsoft SQL Server 2008
Last Comment
ttist25
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionSOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
If you're going to store dates in a varchar format, use 'YYYYMMDD'. This format is always interpreted correctly, so you never need any error-prone and time-consuming conversion codes to use it.
ASKER
Thanks - sorry with the delay awarding points.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Angel - I did a brief review of the article you sent. Thank you. I will need to review it again (probably several times) to get it through my thick skull before I try to implement it. :)
Esolve - thanks for your response as well. In your example you use the date from my example (25-JAN-13). I should've been more specific and said I am trying to "batch" convert the dates that are in the format dd-mmm-yy to mm/dd/yyyy (although after reading the article I'm not sure the slash format is what I want to do).
Thanks again for your help and especially the article (teach a man to fish although a fish would taste great right now).