SQLServer获取指定时间段日期 函数
程序员文章站
2022-06-27 11:46:41
...
连续日期
ALTER FUNCTION [dbo].[fun_getDateListByStartAndEnd]
(
@startTm varchar(30),
@endTm varchar(30)
)
RETURNS TABLE
AS
RETURN
(
SELECT DATEADD(dd, number, @startTm) AS MYTM,cast(MONTH(DATEADD(dd, number, @startTm)) as varchar)+'月'+cast(DAY(DATEADD(dd, number, @startTm)) as varchar)+'日' AS MYDAY
FROM master.dbo.spt_values
WHERE type = 'P' AND number <= DATEDIFF(DAY,CONVERT(varchar(20), @startTm, 23),CONVERT(varchar(20), @endTm, 23))
)
连续月
ALTER FUNCTION [dbo].[fun_getMonth]
(
@startTm varchar(30),
@endTm varchar(30)
-- @stcd varchar(8)
)
RETURNS TABLE
AS
RETURN
(
SELECT DATEADD(mm, number, @startTm) AS MYTM,
cast(MONTH(DATEADD(mm, number,@startTm)) as varchar)+'月' AS MYDAY
FROM master.dbo.spt_values WHERE type = 'P' AND number<= DATEDIFF(mm,CONVERT(varchar(20),@startTm, 23),CONVERT(varchar(20), @endTm, 23))
)
其他自行改造