Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: finding # of days between two dates?
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 Sat Nov 09 2002 - 08:17:02 CST