Home » SQL & PL/SQL » SQL & PL/SQL » Diff b/w two dates
Diff b/w two dates [message #210051] Tue, 19 December 2006 02:40 Go to next message
Messages: 23
Registered: November 2006
Location: India
Junior Member


I need a difference b/w two date’s

Select sysdate – (sysdate-2) from dual

Result will be like

Days Hours Min Sec Millisec
2 0 0 0 0

Re: Diff b/w two dates [message #210052 is a reply to message #210051] Tue, 19 December 2006 02:44 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Thanks to our fantastic search feature:
difference between two dates
A way to extract the difference between 2 dates in hours and minutes
How to calculate the difference of dates in HH:MI:SS format

Previous Topic: Clearing Redo logs
Next Topic: Create User problem
Goto Forum:

Current Time: Fri Oct 28 16:41:24 CDT 2016

Total time taken to generate the page: 0.16882 seconds