Date Conversion

dudam · Post by **dudam** » Fri May 24, 2013 12:09 am

Hi,

Date format from MM/DD/YYYY to CCYY/MM/DD
we are using DS 8.5 version

Can You Plz help me any one..

Thanks in Advance.

sendmkpk · Post by **sendmkpk** » Fri May 24, 2013 2:39 am

did u try a search on it

ray.wurlod · Post by **ray.wurlod** » Fri May 24, 2013 3:30 am

Why should U search on it, given that it's dudam's question?

ray.wurlod · Post by **ray.wurlod** » Fri May 24, 2013 3:32 am

What is the data type of the source and of the target?

Date data type is stored in a binary format, and does not have a format.

If you're reading from a string and writing to a string, convert from string to date and then back to string, each time with an appropriate format specification.

chulett · Post by **chulett** » Fri May 24, 2013 6:55 am

As noted, a DATE has no format but a date in a STRING does. Clarify for us what your source and target types are.

chulett · Post by **chulett** » Wed May 29, 2013 7:01 am

dudam emailed and said wrote:the Source and Trgt as datatype is Date

First off, reply here not via private email. Those I normally ignore.

So bottom line there is no conversion needed. As noted, a date is a date and has no format.