Archive for January, 2015

Use the Below to convert julian date to calendar date in Netezza

TO_DATE(substr(Your_date_column,1,4) || ‘0101’,‘YYyyMMDD’ )+TO_NUMBER(SUBSTR(Your_date_column,5,3),‘999’)-1.

Informatica:-

Convert Calendar Date to Julian date in Informatica.
TO_CHAR(SESSSTARTTIME, ‘YYYYDDD’)
Note:- Instead of  SESSSTARTTIME use the column on which conversion is required.