以某种方式将月份转换为4个季节的Sql查询

Question

我需要在sql server中编写一个查询，让我在我的表中注册月份，并以某种方式将这些月份分为4个季节(秋、秋、春、夏)。有人知道怎么做吗？？

Answer 1

一种方法是case。你的问题并没有阐明逻辑，但这里有一个例子：

(case when month(date) in (12, 1, 2) then 'winter'
      when month(date) in (3, 4, 5) then 'spring'
      when month(date) in (6, 7, 8) then 'summer'
      when month(date) in (9, 10, 11) then 'autumn'
 end) as season

Answer 2

(CHOOSE(month(TheDate),'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 
 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Winter')) 

Answer 3

林诺夫的回答是：

case dateatepart(quarter,idate)  
      when 1 then 'winter'
      when 2 then 'spring'
      when 3  then 'summer'
      when 4 then 'autumn'
 end as season