Re: Leap Year

["Beller, Jay" <JBeller@LBISOFTWARE.COM>]

Don't forget years that ...
mod(year, 100) = 0 is NOT a leap year and
mod(year, 400) = 0 IS a leap year

-----Original Message-----
From: Andy Brook [mailto:Andrew.Brook@HANCORP.CO.UK]
Sent: Wednesday, April 18, 2001 12:09 PM
To: SQR-USERS@list.iex.net
Subject: Re: Leap Year


Just do a mod (year,4) If the returned value is 0 then the year is leaping.
I dont know if there is a mod function in SQR but write your own or use your
rdbms's mod function.

Andy

-----Original Message-----
From: Tajinder Chahal [mailto:Tchaha@ROUSHIND.COM]
Sent: 18 April 2001 16:53
To: SQR-USERS@list.iex.net
Subject: Leap Year


Does anyone know if there is a function in SQR which can determine if the
year is a leap year or not?

Thanks in Advance
Tajinder