Re: Julian date from Oracle NNN.NN

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/06/09
Message-ID: <3940EB80.9CA631FA@edcmail.cr.usgs.gov>#1/1

Just take the difference between today and Jan 1. For example:

SQL> SELECT to_char(sysdate,'YYYY') || '.' ||   2 to_char(trunc(sysdate - to_date('JAN-01-2000','MON-DD-YYYY'))+1)   3 AS JULIAN_DATE
  4* FROM DUAL JULIAN_DATE

---

2000.161

HTH,
Brian

ken k wrote:
>
> What is the best way to get a REAL julian date out of an Oracle
> date, ie: # of days in current year and fractional part for the
> time.
>
> Thanks,
>
> Ken k
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Jun 09 2000 - 00:00:00 CDT