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
kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India
Junior Member

Hi,

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


Thanks,
Kanmani
Re: Diff b/w two dates [message #210052 is a reply to message #210051] Tue, 19 December 2006 02:44 Go to previous message
Maaher
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

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


Current Time: Tue Dec 06 10:27:02 CST 2016

Total time taken to generate the page: 0.08984 seconds