select to_char(to_date(:julian_date,'J'),'yyyy-mm-dd')