获取某年某月的第一天和最后一天的Sql Server函数

最新推荐文章于 2022-08-30 11:26:37 发布

转载最新推荐文章于 2022-08-30 11:26:37 发布 · 1.8k 阅读

文章标签：

#sql server #function #go

本文提供了两个SQL函数：获取指定年月的第一天和最后一天的日期。通过输入年份和月份，可以返回对应日期，适用于多种数据库操作场景。

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        RickyLin
-- Create date: 2007-11-27
-- Description:    获取某年某月的第一天的日期
-- =============================================
ALTER FUNCTION fnGetFirstDayOfMonth
(
    @Year SMALLINT
    , @Month    TINYINT
)
RETURNS SMALLDATETIME
AS
BEGIN
    DECLARE @FirstDay SMALLDATETIME
    DECLARE @Str    VARCHAR(10)
    SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'

    SET @FirstDay = Convert(SMALLDATETIME, @Str)

    RETURN @FirstDay

END
GO

-- =============================================
-- Author:        RickyLin
-- Create date: 2007-11-27
-- Description:    获取某年某月的最后一天的日期
-- =============================================
CREATE FUNCTION fnGetLastDayOfMonth
(
    @Year SMALLINT
    , @Month    TINYINT
)
RETURNS SMALLDATETIME
AS
BEGIN
    DECLARE @LastDay SMALLDATETIME
    DECLARE @Str    VARCHAR(10)
    SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'

    SET @LastDay = DateAdd(d, -1, DateAdd(m, 1, dbo.fnGetFirstDayOfMonth(@Year, @Month)))

    RETURN @LastDay

END
GO