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.
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.
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).
Scott Pletcher
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.
ttist25
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!
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).