minutes between two dates
453745Jun 4 2008 — edited Jun 4 2008i want to retrieve the total elapsed time in minutes between two dates
SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "sysdate"
FROM dual;
SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM sys.v_$instance;