OraFAQ Forum: SQL & PL/SQL » Diff b/w two dates

Home » SQL & PL/SQL » SQL & PL/SQL » Diff b/w two dates

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Diff b/w two dates [message #210051]

Tue, 19 December 2006 02:40

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

Report message to a moderator

Re: Diff b/w two dates [message #210052 is a reply to message #210051]

Tue, 19 December 2006 02:44

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 25 14:22:58 CDT 2017

Total time taken to generate the page: 0.14643 seconds