How to convert normal date to julian date in informatica

Suppose my date is localtimestamp datatype and I need to convert it into Julian date||HHMM in informatica

Where Julian date is JJJ HHMM is hours and minutes

For example today is 29-10- 2021 Julian date is 302,output should come with concat of JJJHHMM

1 answer

  • answered 2021-10-30 04:13 Koushik Roy

    I think you are looking for modified julian date which is just a number. If you are looking for modified julian date, then use -


    If you are looking for normal Julian date (format is yyyyddd) then use


How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum