Re: Adding HOURS to DATE

Sybrand,

[Quoted] Thanks, but nothing is obvious. Are you implying that the lowest granularity of a DATE field is 24 hours (1 day), or that to add, say 8 hours, I have to add 8/24 of a DAY? And how do I do that?

/Joel (finkel_at_sdi.com)

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:955987812.16693.0.pluto.d4ee154e_at_news.demon.nl...
> The unit of a date column is one day. The rest is fairly obvious, I
imagine.
>
> Hth,
>
> 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:23:44 CEST