Re: Adding HOURS to DATE
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 17 Apr 2000 18:12:19 +0200
Message-ID: <955987812.16693.0.pluto.d4ee154e_at_news.demon.nl>
Date: Mon, 17 Apr 2000 18:12:19 +0200
Message-ID: <955987812.16693.0.pluto.d4ee154e_at_news.demon.nl>
[Quoted] The unit of a date column is one day. The rest is fairly obvious, I imagine.
Hth,
[Quoted] Sybrand Bakker, Oracle DBA
Joel Finkel <finkel_at_sdi.com> schreef in berichtnieuws
N8GK4.26163$hh2.806093_at_news.flash.net...
> Folks,
>
> I'd like to know if there is a canonical method to add a specified number
of
> hours to a value in a DATE field. I am aware that the function NEW_TIME
can
> be used to easily convert among some time zones, but not that many. I
need
> a function to add (or subtract) 10 hours, 8 hours, etc. to a given DATE.
>
> Thanks in advance for all suggestions.
>
> /Joel (finkel_at_sdi.com)
>
>
Received on Mon Apr 17 2000 - 18:12:19 CEST