留个底:
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
--=============================================
--Author:RickyLin
--Createdate:-11-27
--Description:获取某年某月的第一天的日期
--=============================================
ALTERFUNCTIONfnGetFirstDayOfMonth
(
@YearSMALLINT
,@MonthTINYINT
)
RETURNSSMALLDATETIME
AS
BEGIN
DECLARE@FirstDaySMALLDATETIME
DECLARE@StrVARCHAR(10)
SET@Str=Cast(@YearASVARCHAR(4))+'-'+Cast(@MonthASVARCHAR(2))+'-1'
SET@FirstDay=Convert(SMALLDATETIME,@Str)
RETURN@FirstDay
END
GO
--=============================================
--Author:RickyLin
--Createdate:-11-27
--Description:获取某年某月的最后一天的日期
--=============================================
CREATEFUNCTIONfnGetLastDayOfMonth
(
@YearSMALLINT
,@MonthTINYINT
)
RETURNSSMALLDATETIME
AS
BEGIN
DECLARE@LastDaySMALLDATETIME
DECLARE@StrVARCHAR(10)
SET@Str=Cast(@YearASVARCHAR(4))+'-'+Cast(@MonthASVARCHAR(2))+'-1'
SET@LastDay=DateAdd(d,-1,DateAdd(m,1,dbo.fnGetFirstDayOfMonth(@Year,@Month)))
RETURN@LastDay
END
GO