判断指定年份是否为闰年

最新推荐文章于 2023-12-06 18:45:00 发布

huang714

最新推荐文章于 2023-12-06 18:45:00 发布

阅读量233

点赞数

分类专栏： SQL Server

本文链接：https://blog.csdn.net/huang714/article/details/105047952

版权

SQL Server 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      Insus.NET
-- Create date: 2019-07-01
-- Update date: 2019-07-01
-- Description: 指定年份是否为闰年
-- =============================================

CREATE FUNCTION [dbo].[svf_IsLeapYear] ( 
    @Year SMALLINT 
)
RETURNS BIT
AS
BEGIN
  DECLARE @rtv BIT = 0  

   IF (@Year >= YEAR([dbo].[svf_LowDate]()) AND @Year <= YEAR([dbo].[svf_HighDate]()))
   AND ((@Year % 4 = 0 AND @Year % 100 != 0) OR @Year % 400 = 0)
        SET @rtv = 1

    RETURN @rtv
END
GO

Source Code