SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Maysarah / Is_Leap Function / Latest Posts

RE: Is_Leap Function

jofa — Tue, 19 Aug 2008 03:09:37 GMT

You could get the same result from something likeisdate(cast(@year as char(4)) + '-02-29')

RE: Is_Leap Function

Maysarah — Wed, 13 Aug 2008 13:25:23 GMT

I Liked it :)

RE: Is_Leap Function

nigel. — Tue, 12 Aug 2008 02:52:09 GMT

Or alternatively this:[code]select IsLeapYear = case when day(dateadd(day,-1,dateadd(month,2,dateadd(year,@year-1900,0)))) = 29 then 1 else 0 end [/code]Which basically calculates the day before March 1st.

Is_Leap Function

Maysarah — Fri, 20 Jun 2008 08:37:18 GMT

Comments posted to this topic are about the item [B]Is_Leap Function[/B]