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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: leap year

Re: leap year

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 25 May 2005 11:55:45 +0800
Message-ID: <5e30486205052420551ea89261@mail.gmail.com>


As well as what others have said, you'll need a little smarts to know whether the boundary dates fall before or after Feb 29, just in case the boundary years are indeed leap years.

hth
connor

On 5/24/05, Inessa Weiner <ikar_at_med.cornell.edu> wrote:

>=20

> Hi,
>=20

> I need to write a PL/SQL function to
> show how many times the leap year occurred between two dates.
> The maximum range between dates is 10 years.
>=20

> Please help.
> Thanks,
> Inessa.

>=20
>=20
--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 25 2005 - 00:00:33 CDT

Original text of this message

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