Julian to DD/MM/YYYY format

scorpion · Post by **scorpion** » Thu Jan 31, 2008 8:30 am

Hi ,

Can some one help me to convert an julian date to DD/MM/YYYY format?

Thanks,

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2008 8:38 am

What kind of "Julian" date is it? There is no universal consensus about what a Julian date is. So what's yours? For example it is the ordinal day number in the current year, or a number of days/seconds/microseconds since some arbitrary zero?

scorpion · Post by **scorpion** » Thu Jan 31, 2008 8:46 am

I have values in my julian date format like:

39424,
38725
39488

thanks

chulett · Post by **chulett** » Thu Jan 31, 2008 8:52 am

And do you have any idea what those three dates should be?

scorpion · Post by **scorpion** » Thu Jan 31, 2008 8:55 am

yes those are:

Dec 10 2007
Jan 10 2006
Feb 12 2008

My source is Sybase tables.

I need them in my out put as:

10/12/2007
10/01/2006
12/02/2008

scorpion · Post by **scorpion** » Thu Jan 31, 2008 9:18 am

can any one give me some idea to acheive this ?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2008 4:26 pm

These appear to be "number of days since an arbitrary zero" type Julian dates. Once you work out what that "day zero" is, you can map that date onto DataStage's Julian date and be able to use the offset to convert your dates.