给定某个的日期，获取小于等于该日期的月代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】给定某个的日期，获取小于等于该日期的月

作者:乔依 / 发布于2016/4/26/ 686

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 行受影响)

试试其它关键字

同语言下

可能有用的

乔依贡献的其它代码(16)