to_char(to_date(julian date, julian date format),gregorian date format) At 05:45 AM 15/02/2005, Jaffar_DBA wrote: >If I need to know the 100th day of this year, like, If I pass value >100, want to extract the 100th day of the given year. Sunday 21, >March, 2005. something like that. Regards Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- //www.freelists.org/webpage/oracle-l