OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Date function

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

Date function [message #18816]

Fri, 15 February 2002 08:36

Bill S
Messages: 2
Registered: February 2002

Junior Member

I need to select data based on a date minus 2 hours.
Something like this:
select *
from table1
where date1 < sysdate - [[2 hours]];
Is there an easy wat to do this?

Thanks,
Bill
Oracle 8i

Report message to a moderator

Re: Date function [message #18817 is a reply to message #18816]

Fri, 15 February 2002 09:12

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select *
from table1
where date1 < sysdate - 1/12;

Report message to a moderator

Thanks! [message #18819 is a reply to message #18816]

Fri, 15 February 2002 10:14

Bill S
Messages: 2
Registered: February 2002

Junior Member

(nt)

Report message to a moderator

Previous Topic:	PL/SQL SYSTEM FUNCTION
Next Topic:	Passing a parameter list for IN clause in cursor.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 05 00:23:11 CDT 2025