| SYSDATE Minus Minutes [message #294150] |
Wed, 16 January 2008 10:50  |
amardilo
Messages: 37
Registered: February 2007
|
Member |
|
|
Hi there.
I have a PL/SQL procedure that needs to get all fields from a table that were created 25 minutes ago. I know if I do SYSDATE - x (x = value) it will take days away from the current date but how do I do this for minutes and hours?
Anyone know the answer?
|
|
|
|
|
|
|
|
|
|
| Re: SYSDATE Minus Minutes [message #294165 is a reply to message #294152] |
Wed, 16 January 2008 11:28  |
amardilo
Messages: 37
Registered: February 2007
|
Member |
|
|
| Michel Cadot wrote on Wed, 16 January 2008 10:52 | 1 hour = 1/24 day
1 minute = 1/1440 day
1 second = 1/86400 day
Regards
Michel
[Edit: change 12 to 24, see below]
|
Thanks for that. Should have known it would be that simple.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
