Home Forums SQL Server 7,2000 Administration Leap Year got Me ... Help! RE: Leap Year got Me ... Help!
AJ Ahrens
SSC-Insane
Points: 20676
More actions
January 19, 2005 at 12:56 pm
#538162
IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1
BEGIN
PRINT 'Leap year'
END
ELSE
PRINT 'Not a leap year'
Good Hunting!
AJ Ahrenswebmaster@kritter.net