Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: finding # of days between two dates?
Amen -- its all about egotism, yet I am not sure they appreciate it.
"Mike Cohen" <mcohen_at_attbi.com> wrote in message
news:9a742dd3.0211111351.3263dc3a_at_posting.google.com...
> Hi,
>
> The Original Poster here.
>
> To those of you who offered up answers to my questions. Thank you
> very much.
>
> For those of you who had an issue with me actually asking a question
> to the group: I've only been prgramming for a few years now, but one
> of the first things I learned is that there are people out there such
> as yourselves who don't have much except for your vast knowledge and
> possible guru-shipness (is that even a word) of a particular subject.
> Some of you choose to use this as your way of controlling your little
> world and maybe even feeling a little powerful. To that I say all the
> more power to you, but c'mon, get a life fellas.
>
> Mike
>
>
> "Bob Redding" <bobreddi_at_bellsouth.net> wrote in message
news:<XH8z9.9260$ds6.3533_at_news.bellsouth.net>...
> > If the dates are stored in Oracle date fields, simply subtract the
oldest
> > from the more current date. Otherwise, use the to_date function to
subtract
> > the dates.
> >
> > "Mike Cohen" <mcohen_at_attbi.com> wrote in message
> > news:9a742dd3.0211081301.63e8791_at_posting.google.com...
> > > Hi,
> > >
> > > How would I find the number of days between two Oracle dates? Is
> > > there a simple function I can utilize?
> > >
> > > Thanks!!
> > >
> > > Mike
Received on Tue Nov 12 2002 - 11:46:55 CST
![]() |
![]() |