Re: help: adding an hour to a DATE datatype...
From: Cal Wooten <clm_at_onramp.net>
Date: 1995/09/27
Message-ID: <44amnu$asr_at_news.onramp.net>#1/1
Date: 1995/09/27
Message-ID: <44amnu$asr_at_news.onramp.net>#1/1
In message <447qgi$iro_at_celebrian.otago.ac.nz>, Craig Neal <coneal_at_saturn.otago.ac.nz> writes:
>This is an easy question, but I just can't quite figure out how to do it
>exactly, i.e. how do you add n hours to a date datatype in SQL*Plus. Any
>help would be greatly appreciated,
>
>Craig Neal
>Department of Information Science
>University of Otago
>New Zealand
>email: coneal_at_saturn.otago.ac.nz
>
Adding 60/1440 to sysdate should return one hour from now.
Good luck.
Cal
Received on Wed Sep 27 1995 - 00:00:00 CET