Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> format a date to Julian 'YYYYDDD'
Hi,
The query
select to_char(sysdate,'J') from dual
returns '2451515'
How can I format it to 'YYYYDDD' (in Julian) ? I.e. not something like 1999336 (which is in Gregorian)
TIA Andrew
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Dec 02 1999 - 15:38:45 CST
![]() |
![]() |