Convert date to Julain date format in datastage

Veni · Post by **Veni** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.