Startup time

Startup time

select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup time"
from v$instance
/

Output:

1  select     to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup time"
  2* from       v$instance
SQL> /

Startup time
---------------
02:55 17-MAY-08