The julian date is the year plus the day number of the year.  Today (Aug. 24, 2001) is 2001236 or 01236, since today is the 236th day of 2001.

"Adams, Matthew (GEA, 088130)" wrote:

 

The v$instance table has the following two entries in
Oracle7.

STARTUP TIME - Julian                  2452043
STARTUP TIME - SECONDS                   9476

Doing the obligitory RTFM, I find all it
says is that STARTUP TIME - Julian is the
startup date and time in Julian format.
(Thanks oracle, that's big help.)

What is the Julian calender? How do you translate this
number?

----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
                 - Larry Wall (creator of Perl)

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Reply via email to