Hello

I did it in my C++ applications in the following way:

* all records contains a Timestamp type column

* the timestamp is stored in a temporary location while the application reads...

A simple solution is the basic test for leap year:

Declare @nYear int

Declare @bLeapYear int

SET @nYear = Year( getdate())

SET @bLeapYear = 0

if ((( @nYear % 4) = 0) AND (((...