Re: PL/SQL code for calculating time between two dates?

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 5 Jun 2003 05:25:29 -0700
Message-ID: <1a8fec49.0306050425.4860ec6_at_posting.google.com>


you mean fractions, surely?

afilonov_at_yahoo.com (Alex Filonov) wrote in message news:<336da121.0306040638.32d144d5_at_posting.google.com>...
> "Dražen Klisurić" <drazen.klisuric_at_sb.tel.hr> wrote in message news:<bbkevv$5e4l$1@as201.hinet.hr>...
> > Is ther any function to calculate number of days, monts and years between
> > two dates in PL/SQL.
> > Thanks.
>
> months_between gives you difference between dates in months. Substraction
> gives you difference in days. Both can have fractures. Read Oracle SQL
> documentation for more information.
Received on Thu Jun 05 2003 - 14:25:29 CEST

Original text of this message