Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Dates

Re: Dates

From: Sigmar Wiesmayr <wis_at_ecolog.at>
Date: 2000/04/14
Message-ID: <38F6D2B7.256014BA@ecolog.at>#1/1 






Just subtract them:



select TO_DATE('01.01.2000','DD.MM.YYYY') - TO_DATE('01.01.1999','DD.MM.YYYY')
from dual



WieSi



Sonia Gillespie wrote:



> There is a months_between method to calculate the months between a certain

> date.  Is there a way of calculating the days between two dates?

>

> --

> Sonia Gillespie

> E-mail: sonia_gillespie_at_lagan.com

Received on Fri Apr 14 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US