OraFAQ Forum: SQL & PL/SQL » SYSDATE Minus Minutes

Home » SQL & PL/SQL » SQL & PL/SQL » SYSDATE Minus Minutes

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

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?

Report message to a moderator

Re: SYSDATE Minus Minutes [message #294152 is a reply to message #294150]

Wed, 16 January 2008 10:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1 hour = 1/24 day
1 minute = 1/1440 day
1 second = 1/86400 day

Regards
Michel

[Edit: change 12 to 24, see below]

[Updated on: Wed, 16 January 2008 10:57]

Report message to a moderator

Re: SYSDATE Minus Minutes [message #294154 is a reply to message #294152]

Wed, 16 January 2008 10:55

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

..Unless you live in a time zone where the day has 24 hours. Grin

Grin

Report message to a moderator

Re: SYSDATE Minus Minutes [message #294155 is a reply to message #294154]

Wed, 16 January 2008 10:56

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Laughing

Embarassed

Fixed.
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	query execution life cycle
Next Topic:	ALERT LOGS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 05:02:24 CDT 2025