Convert Julian date to calendar date in Netezza

Posted: January 28, 2015 in Netezza

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.


Convert Calendar Date to Julian date in Informatica.
Note:- Instead of  SESSSTARTTIME use the column on which conversion is required.






  1. Anand says:

    Netezza query I tried but it is giving wrong value and not as expected.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s