-
Nice One
What I don't understand is I think I ran this earlier:
select to_char(to_date(a.value, 'J') + (b.value/60/60/24), 'DD-MM-YYYY HH24:MI:SS')
from v$instance a, v$instance b
where a.key = 'STARTUP TIME - JULIAN'
and b.key = 'STARTUP TIME - SECONDS'
/
and it came up with 22:10 ?!
I type it in now and it comes up with 22:22!
Guess there must be a suttle difference, but I've closed the SQL *Plus window it was in now.... Oh Well.!
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|