Re: date/time arithmetic

rbowen_at_access3.digex.net (Raymond Bowen) writes:

>I am writing a stored procedure that is attempting to add three
>hours to a date (i.e. SYSDATE). Any idea in how to do this?

raymond,

this should work for you:

select sysdate+3/24 from dual;

or some such. just remember, you're adding days (or fractions thereof), so 10 minutes would be +10/1440. get it?

douglas
delphi consulting services, inc.
dacummins_at_delphi.com
:-> Received on Fri Mar 10 1995 - 01:00:36 CET