Re: How to add or subtract 10 minutes from a date?

In article <eqp8as44360fk4ld9rnavgp0be9f0fluhr_at_4ax.com>,   kenmn_at_tds.net wrote:
> Thanks in advance everyone.
>
> Assume I have a date like '12/31/99 11:59:30' and I want to add 10
> Minutes to it.
> I need to do this in s cursor select in a Before Insert Trigger that
> goes like:
> CURSOR cur is select * from xxxx X where X.dateAndTime <
> :(new.DateTime - 10 Minutes);
>
> I haven't been very successful in figuring it out. A worse date would
> be '02/28/00 11:59:30' + 10 minutes.
>
> How can I do this?
>
> Best,
>
> Ken Sproule
> kenmn_at_tds.net
>

Try something like this:

 UT1> l
  1 select to_char(sysdate,'HH24:MI:SS'),   2 to_char(sysdate + 10/1440,'HH24:MI:SS')   3* from dual
UT1> /

TO_CHAR( TO_CHAR(
-------- --------
16:02:22 16:12:22

All Oracle date columns store the date and time so to add time you add a fraction of a day.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 15:10:51 CST