SQL SERVER LEAP YEAR(轉)

只適用在SQL SERVER 2012 參考

SQL SERVER – Detecting Leap Year in T-SQL using SQL

 SELECT (IIF(DATEPART(dd,(EOMONTH(CONCAT(1910,'0201')))) = 29,1,0))


其他版本SQL SERVER 參考

Different ways to find out a Leap Year

再加一個INFORMIX datediff