date conversion

lfong · Post by **lfong** » Thu Nov 22, 2007 11:48 am

What would be the best way to convert a date in format yyddd (mainframe julian)?

Thanks

chulett · Post by **chulett** » Thu Nov 22, 2007 2:36 pm

Have you tried searching the pdf documentation for 'julian'? That's where I would start in your shoes.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 22, 2007 2:53 pm

You also need a business rule (CENTURYPIVOT) that defines how to handle two-digit years.

If the volumes are not large, a BASIC Transformer stage can do this easily. But what format does your target need to be? Here is one example (for a BASIC Transformer stage) that generates an ISO 8601 format date (YYYY-MM-DD).

Code: Select all

Oconv(Iconv(InLink.JulianDate, "D2YJ"),"D-YMD[4,2,2]")