展开全部
取季32313133353236313431303231363533e4b893e5b19e31333332633061度数字然后再CASE WHEN 就好啦﹐参考以下代码DECLARE @TB TABLE(TIME DATETIME)
INSERT INTO @TB VALUES('2013-02-09 11:22:59.997')
INSERT INTO @TB VALUES('2013-05-07 13:12:51.333')
INSERT INTO @TB VALUES('2013-07-07 15:42:22.633')
INSERT INTO @TB VALUES('2013-10-20 19:29:22.783')
SELECT *,CASE WHEN DATEPART(QQ,TIME)=1 THEN DATEADD(D,-1,'2013-04-01 23:59:59.997')
WHEN DATEPART(QQ,TIME)=2 THEN DATEADD(D,-1,'2013-07-01 23:59:59.997')
WHEN DATEPART(QQ,TIME)=3 THEN DATEADD(D,-1,'2013-10-01 23:59:59.997')
WHEN DATEPART(QQ,TIME)=4 THEN DATEADD(D,-1,'2014-01-01 23:59:59.997')
END AS QUARTER
FROM @TB
效果:
TIME QUARTER
---------------------------------- - -----------------------------------
2013-02-09 11:22:59.997 2013-03-31 23:59:59.997
2013-05-07 13:12:51.333 2013-06-30 23:59:59.997
2013-07-07 15:42:22.633 2013-09-30 23:59:59.997
2013-10-20 19:29:22.783 2013-12-31 23:59:59.997