Date Conversion

[vj_meghani]

Hi

I am trying to convert date from yyyy/dd/mm to mm/dd/yyyy
I was also trying to convert the timestamp to dd/mm/yyyy.
I am not able to converte it. Can anyone tell what should i do?

vaishali [/code]

[kcbland]

Search this forum for the oft covered ICONV and OCONV functions, as well has how to use substring notation ( variable[x,y] ) and FIELD functions to parse dates.

[ray.wurlod]

You may find the article Date Conversion Demystified useful too.

Beware that some stage types convert the date into DataStage internal format (an integer), while other stage types don't. You did not specify which stage type you are using.

Basically, though, if the dates are arriving as character strings, then you can use character string manipulation (substring and concatenation) to rearrange the characters. For example:

Code: Select all

TheDate[9,2] : "/" : TheDate[6,2] : "/" : TheDate[1,4]

A similar technique can be used if the source date is a timestamp.

Alternately you can convert the source date into internal format (if DataStage has not done so already), then back into an appropriate external format. The former uses the Iconv() function, the latter uses the Oconv() function. For example:

Code: Select all

Oconv(Iconv(TheDate, "DYMD"), "D/MDY[2,2,4]")