Re: date/time arithmetic
From: Eric Pierce <sac50216_at_saclink1.csus.edu>
Date: 4 Mar 1995 01:19:25 GMT
Message-ID: <3j8f6t$g57_at_news.csus.edu>
: --
: ==========================================================
: Raymond C. Bowen III
: Principal Computer Consultant
: P.O. Box 32311
: Baltimore, Maryland 21208-8311
: Voice Mail (410) 922-6311 Fax (410) 922-6311
: e-mail: rbowen_at_access.digex.net
Date: 4 Mar 1995 01:19:25 GMT
Message-ID: <3j8f6t$g57_at_news.csus.edu>
Raymond Bowen (rbowen_at_access3.digex.net) wrote:
: 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 C. Bowen III
: Principal Computer Consultant
: P.O. Box 32311
: Baltimore, Maryland 21208-8311
: Voice Mail (410) 922-6311 Fax (410) 922-6311
: e-mail: rbowen_at_access.digex.net
My server is down for backups, so I can't test it:
select to_char(sysdate, "HH:MI:SS"), to_char(sysdate+3/24, "HH:MI:SS") from dual;
I vaguely recall that you can add/subtract integer values as days to dates, so 3/24 is 3 hours?
Any corrections or other feedback is appreciated,
EP Received on Sat Mar 04 1995 - 02:19:25 CET