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.!
Why terry complicate when things can be made simple..
because problem solving is cool :)
plus now i know a bit more about dates.
however getting the time the oracle processes connected seems like an easier way for general use :) just want to select where username is null so you don't have to filter through normal user sessions.
Well, looking in v$instance in Oracle 8i is the easiest way of all.
I just wondered how it was done from v$Instance in Oracle 7 - and I too learnt a little more about data handling.
Why not just run:
select min(to_char(LOGON_TIME,'dd-mon-yyyy hh:mi:ss pm'))
That's even easier still for Oracle 7... Although once you have a query written, any can be used just as quickly :)
[Edited by TerryD on 11-17-2000 at 12:37 PM]