Converting Julian date format to db2 format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bhaskar.bogadi
Premium Member
Premium Member
Posts: 4
Joined: Wed Aug 27, 2008 3:29 am

Converting Julian date format to db2 format

Post by bhaskar.bogadi »

Hi ,

I'm getting the Source as YYDDD i.e julian format from the csv (comma separated) file

Ex: 08046
08 -- 2008(year)
046-- day of the year(feb 15)

YYDDD as Varchar format

I need to convert in to db2 format(YYYY-MM--DD)

Pls help me on converting the julian format to date format
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”