Hi,

I have stored my dates in a OrderDate field in the following fashion
Assuming that its a varchar field

OrderDate

2006-10-09
10-09-06
09-10-2006
10 Sep 2006

I need a program which should outputs the format as shown below

YYYY-MM-DD
DD-MM-YY
MM-DD-YYYY
DD MON YYYY



Chandru

__________________
Thanks,
Chandra

Why? They're already in those formats. Do you mean something else for the output?

--Jeff Moden

Say for Eg.
1. OrderDate - 12/10/2006
2. OrderDate - 09/05/06

I need to verify whether OrderDate is in this format - dd/mm/yyyy
As in 2nd eg. my format should be mm/dd/yy

System should verify whether the date stored in the database is valid date of particular format.








Chandru

There's no way to tell if a date like 11/12/2006 is in the mm/dd/yyyy format or the dd/mm/yyyy format unless it's an absolute given that 11/12/2006 will ALLWAYS be in the mm/dd/yyyy format and that 11/12/06 (has only a 2 digit year) will ALWAYS be in the dd/mm/yy format. Can you make that guarantee in your data?

--Jeff Moden

you can do something like that using case statements, for example check if the fifth character is a "-" then you know your using CCYY-MM-DD. You have to add conditions that cover all your possible types though. Also if the third and the seven characters are space then your "DD MON YYYY". Can get very complexed depending on how many date formats your dealing with.