Try v$thread instead
jack
Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on
24-08-2001 20:21:31
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Or
http://www.oracledba.co.uk/tips/uptime.htm
hth
connor
--- [EMAIL PROTECTED] wrote:
Try v$thread instead
jack
Adams, Matthew (GEA, 088130)
[EMAIL PROTECTED]@fatcity.com on
24-08-2001 20:21:31
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
On Friday 24 August 2001 12:00, Scott Canaan wrote:
The julian date is the year plus the day number of the year.nbsp; Today
Scott,
That's a popular misconception. While that may be a
useful date string, it is not a Julian date. A julian
date is somewhat more complex than that.
If it
actual date = to_date(junion_date_as_number, 'J');
seconds = actual seconds ... as long as they are less than 86400
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
Title: startup time v7
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
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