Re: PL/SQL code for calculating time between two dates?
From: Alex Filonov <afilonov_at_yahoo.com>
Date: 4 Jun 2003 07:38:27 -0700
Message-ID: <336da121.0306040638.32d144d5_at_posting.google.com>
Date: 4 Jun 2003 07:38:27 -0700
Message-ID: <336da121.0306040638.32d144d5_at_posting.google.com>
"Dražen Klisurić" <drazen.klisuric_at_sb.tel.hr> wrote in message news:<bbkevv$5e4l$1_at_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 Wed Jun 04 2003 - 16:38:27 CEST