Re: Adding HOURS to DATE

Yes, that's what I am implying, and you should just add 8/24 to your date column. Trust me, it works.

Hth,

Sybrand Bakker, Oracle DBA

Joel Finkel <finkel_at_sdi.com> schreef in berichtnieuws kUGK4.26201$hh2.808245_at_news.flash.net...
> Sybrand,
>
> 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 - 19:55:45 CEST