Re: leap year

  • From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 May 2005 11:55:45 +0800

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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l

Other related posts: