Re: date/time arithmetic
From: James Richard <no email>
Date: Wed, 15 Mar 1995 12:55:11 GMT
Message-ID: <1995Mar15.125511.3838_at_newton.ccs.tuns.ca>
Date: Wed, 15 Mar 1995 12:55:11 GMT
Message-ID: <1995Mar15.125511.3838_at_newton.ccs.tuns.ca>
In article <3j7p1d$73v_at_news3.digex.net> 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 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
SELECT TO_CHAR (SYSDATE + 3/24, 'DD-MON-YY HH24:MI:SS') FROM DUAL;
James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!"
Received on Wed Mar 15 1995 - 13:55:11 CET