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