declare @date datetime set @date='2008-01-01' select cast(datepart(yy,dateadd(month ,-3,@date )) as nvarchar(40))+'年' +cast(datepart(quarter,dateadd(month,-3,@date)) as nvarchar(40))+'季度'
declare @date datetime set @date='2008-02-01'select cast(datepart(yy,dateadd(month ,-3,@date )) as nvarchar(40))+'年' +cast(datepart(quarter,dateadd(month,-3,@date)) as nvarchar(40))+'季度' as shijian
set @dt = getdate()select
case when datepart(quarter , @dt) > 1 then datename(year,@dt) + ' 年 ' + cast(datepart(quarter , @dt) as varchar) + ' 季度'
else cast(datepart(year,@dt)-1 as varchar) + ' 年 4 季度'
endset @dt = '2008-01-01'select
case when datepart(quarter , @dt) > 1 then datename(year,@dt) + ' 年 ' + cast(datepart(quarter , @dt) as varchar) + ' 季度'
else cast(datepart(year,@dt)-1 as varchar) + ' 年 4 季度'
end/*
---------------------------------------------------------------------
2008 年 2 季度(所影响的行数为 1 行)
---------------------------------------------------------------------
2007 年 4 季度(所影响的行数为 1 行)
*/
declare @date datetime
set @date='2008-01-01'
select cast(datepart(yy,dateadd(month ,-3,@date )) as nvarchar(40))+'年' +cast(datepart(quarter,dateadd(month,-3,@date)) as nvarchar(40))+'季度'
declare @date datetime
set @date='2008-02-01'select cast(datepart(yy,dateadd(month ,-3,@date )) as nvarchar(40))+'年'
+cast(datepart(quarter,dateadd(month,-3,@date)) as nvarchar(40))+'季度'
as shijian