date conversion

shaonli · Post by **shaonli** » Thu Mar 06, 2008 2:07 am

My i/p date is in the format yyyy-mm-dd.I want to convert in the format mmddyyyy.
Please suggest.Both the fields(i/p and o/p) datatype is Date.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 06, 2008 2:20 am

Dates, as you would have learned had you conducted a search, do not have any format - they are stored in binary format.

Date format strings specify how to convert between dates and string representations thereof.

ArndW · Post by **ArndW** » Thu Mar 06, 2008 2:21 am

If you are getting a "date" data type then the data is in internal binary form and the field actually has no format at all.

shaonli · Post by **shaonli** » Thu Mar 06, 2008 3:04 am

So is it not possible to convert in the format I specified if the o/p data type is DATE.Please clarify.

shaonli · Post by **shaonli** » Thu Mar 06, 2008 3:07 am

So is it not possible to convert in the format I specified if the o/p data type is DATE.Please clarify.

ArndW · Post by **ArndW** » Thu Mar 06, 2008 3:09 am

A Date datatype has no format. How you display the Date column is dependant upon the display settings of your target system, that is where you need to look.