Search code examples
datastagejulian-date

Conversion of Normal Date ( YYYY-MM-DD ) to Julian Date conversion in datastage

Is there any function to convert Normal Date to Julian Date.

I have used JulianDayFromDate function in transformer but i am not getting expected output .

Sample Input : 

Date -- 2013-02-02

Output Should be:

Julian Date-- 113033

( In Database we can do the query as below )

select to_date(1900000+113033,'YYYYDDD') from dual

But how to convert in Datastage ... ?

Solution

  • Maybe your expectations are wrong - 2456326 is the julian day for 2013-02-02 - the DataStage functions works.

    Check out the Wikipedia documentation for defintions and calculations

    Not sure what your 113033 is but it is not the Julian date or Julian day for the date shown.

    To achieve what you want you have to do the calculation by your own. Besides the year calcuation you could use YeardayFromDate to get the daynumer in the year. So finally it would be something like 

    YearFromDate('2013-02-02') * 1000 - 1900000  +   YeardayFromDate('2013-02-02')