How would you convert date into Julian date format?

We can use the J format string :
SQL > select to_char(to_date(‘29-Mar-2013’,’dd-mon-yyyy’),’J’) as julian from dual;
JULIAN

0 comments: