Converting Date format from YYYY-MM-DD to YYYYMMDD
Moderators: chulett, rschirm, roy
Converting Date format from YYYY-MM-DD to YYYYMMDD
Hi,
My source is a Date datatype in YYYY-MM-DD format.
How can i convert it to Date(8) in YYYYMMDD format?
My source is a Date datatype in YYYY-MM-DD format.
How can i convert it to Date(8) in YYYYMMDD format?
Converting Date format from YYYY-MM-DD to YYYYMMDD
I want the output to be in Date with length 8.
Please provide a solution....
Please provide a solution....
How to change the extended properties of the field?
I am new to DataStage PX.
I tried the following, but got some error.
StringToDate(Convert('-','',Date_Column),"%yyyy%mm%dd")
Error: Failure during execution of operator logic
Conversion error calling conversion routine date_from_string
data may have been lost
I am new to DataStage PX.
I tried the following, but got some error.
StringToDate(Convert('-','',Date_Column),"%yyyy%mm%dd")
Error: Failure during execution of operator logic
Conversion error calling conversion routine date_from_string
data may have been lost
Hi
As shiva4joy said i tested converting yyyy-mm-dd to yyyymmdd using sequential file and in transformer i used convertion string , convert('-','', inputlink_columnname)and changed length properties of datecolumn in column tab in target to 8 and it worked fine. But i did in server job.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Christina wrote:How to change the extended properties of the field?
I am new to DataStage PX.
I tried the following, but got some error.
StringToDate(Convert('-','',Date_Column),"%yyyy%mm%dd")
Error: Failure during execution of operator logic
Conversion error calling conversion routine date_from_string
data may have been lost
hi, it can be simpaly done by Oconv(Iconv(INPUT_LINK,"D-YMD"),"YMD")............
![Smile :)](./images/smilies/icon_smile.gif)
Converting Date format from YYYY-MM-DD to YYYYMMDD
Thanks a lot guys...
The solution given by DSguru2B and ZDC works...
The solution given by DSguru2B and ZDC works...