Page 1 of 1
Date Conversion
Posted: Fri May 24, 2013 12:09 am
by dudam
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.
Posted: Fri May 24, 2013 2:39 am
by sendmkpk
did u try a search on it
Posted: Fri May 24, 2013 3:30 am
by ray.wurlod
Why should U search on it, given that it's dudam's question?
Posted: Fri May 24, 2013 3:32 am
by ray.wurlod
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.
Posted: Fri May 24, 2013 6:55 am
by chulett
As noted, a DATE has no format but a date in a STRING does. Clarify for us what your source and target types are.
Posted: Wed May 29, 2013 7:01 am
by chulett
dudam emailed and said wrote:the Source and Trgt as datatype is Date
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
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.