DSXchange

Hi,

My source is a Date datatype in YYYY-MM-DD format.
How can i convert it to Date(8) in YYYYMMDD format?

you can use convert function to remove '-'.
syntax for the function is Convert('-','', Input_Date_Column)
and you can use substring function ,and syntax is
Input_Date_Column[1,4]:Input_Date_Column[6,2]:Input_Date_Column[8,2]

Will this give the output as date dataype with length 8?

no the output will be string

I want the output to be in Date with length 8.

Please provide a solution....

StringToDate() with the appropriate format mask. Forget about the 'to YYYYMMDD' part, a date is a date.

No conversion is required. Just change the date output format in the extended properties of the field.

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 there,
As DSGuru suggested ...
Just go to
format tab>type defaults and then go for the date ,
change the format string to %yyyy%mm%dd in the output tab,it will work for sequential file as i have done this in past.No need to worry about datatype.



Cheers,
ZDC

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.

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")............

Guys, server solutions will not work in px. Follow ZDC's suggestion. He basically explained what I said earlier.

Thanks a lot guys...

The solution given by DSguru2B and ZDC works...