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.

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.

 

 

 

 

 

Advertisements
Comments
  1. Anand says:

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

    Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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