Code: Select all
select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup Time" from v$instance;
Code: Select all
Startup Time
---------------
10:35 13-JAN-12
Code: Select all
select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup Time" from v$instance;
Code: Select all
Startup Time
---------------
10:35 13-JAN-12