给定某个的日期，获取下于等于该日期的月

最新推荐文章于 2024-01-04 16:01:56 发布

ws_hgo

最新推荐文章于 2024-01-04 16:01:56 发布

阅读量838

点赞数

分类专栏： MSSQL

本文链接：https://blog.csdn.net/ws_hgo/article/details/5266432

版权

MSSQL 专栏收录该内容

64 篇文章 0 订阅

订阅专栏

DECLARE @TIME DATETIME
SET @TIME='2009-05-01'
select convert(nvarchar(6),dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime)),112) '时间'
from master..spt_values where type='P' and
dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime))<=@TIME
时间
------
200901
200902
200903
200904
200905

DECLARE @TIME DATETIME
SET @TIME='2009-01-01'
select convert(nvarchar(6),dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime)),112) '时间'
from master..spt_values where type='P' and
dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime))<=@TIME

时间
------
200901

DECLARE @TIME DATETIME
SET @TIME='2009-10-01'
select convert(nvarchar(6),dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime)),112) '时间'
from master..spt_values where type='P' and
dateadd(month,number,cast(ltrim(ltrim(year(@TIME))+'-01'+'-01') as datetime))<=@TIME

时间
------
200901
200902
200903
200904
200905
200906
200907
200908
200909
200910

(10 行受影响)