Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

minutes between two dates

453745Jun 4 2008 — edited Jun 4 2008
i 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 4 2008
1 comment
337 views