Convert Julian date to calendar date 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

2 thoughts on “Convert Julian date to calendar date in Netezza

  1. Anand January 4, 2016 / 5:50 pm

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

    Like

    • krivamsh January 8, 2016 / 1:51 pm

      Give the input and expected output your looking for.
      Thanks

      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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s