from Date to Julian day

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
reddyamarnath
Participant
Posts: 8
Joined: Thu Jun 17, 2010 1:12 am

from Date to Julian day

Post by reddyamarnath »

Hi ,

I want to convert from today's day to julian day as DDD format.

I have tried the function juliandayfromDate , but it is giving the 7 digit number.
I'm little bit confused whether i can extract the day (DDD which should 3 digit integer) from julian day. Please provide me suggestions on the same. Thanks in Advance.
reddy,amarnath
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What exact output do you want? Anything like MMDDD or DDD is not a julian date, hence the issue you are having. Look at the DateToString() function, I believe that a mask of DDD will get you the ordinal day number.
-craig

"You can never have too many knives" -- Logan Nine Fingers
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

I have heard the term "julian day" incorrectly used to refer to the day-of-the-year before. I'm not sure where this confusing term originates from.
*Edit* It's mentioned here: http://disc.gsfc.nasa.gov/julian_calendar.shtml
Phil Hibbs | Capgemini
Technical Consultant
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yah, it is (unfortunately) a quite common confusion.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply