How to add or subtract 10 minutes from a date?

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

Ken Sproule
kenmn_at_tds.net Received on Fri Feb 11 2000 - 13:50:49 CST