| Date's difference [message #85297] |
Mon, 14 June 2004 05:31  |
Solveiga
Messages: 36
Registered: March 2003
|
Member |
|
|
How to calculate date's difference?
I need to take one date from another and get a duration
can you help?
S
|
|
|
|
| Re: Date's difference [message #85303 is a reply to message #85297] |
Mon, 14 June 2004 22:19  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Simply sustract 1 date from another.
e.g.
SQL> select (sysdate - (sysdate-5)) from dual;
(SYSDATE-(SYSDATE-5))
---------------------
5
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
