Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: startup time v7

Re: startup time v7

From: Scott Canaan <srcdco_at_ritvax.isc.rit.edu>
Date: Fri, 24 Aug 2001 10:44:10 -0700
Message-ID: <F001.00377342.20010824110029@fatcity.com>



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 - matt.adams@appl.ge.com
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 (srcdco@rit.edu)
(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: srcdco@ritvax.isc.rit.edu

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: ListGuru@fatcity.com (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).
Received on Fri Aug 24 2001 - 12:44:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US