DSXchange

Posted: **Thu Jan 12, 2006 3:08 am**

How to convert date to julian date format in datastage

in coming date format is mm/dd/yyyy , i want to convert this date to julian date format.

Posted: **Thu Jan 12, 2006 3:22 am**

Julian means different things to different people. The conversion functions (Iconv() and OConv()) use "ordinal day within the year". If that's what you want use

Code: Select all

Oconv(Iconv(InLink.TheDate, "DMDY"), "D/JY")

(or use "D/YJ" to get year first.

DSXchange

Convert date to Julain date format in datastage

Convert date to Julain date format in datastage