我是这个行业的新手。希望您能帮助我用CASE语句解决以下问题。我需要比较有日期值的两列,但结果将如下图所示。
谢谢 娜耶姆
尝试这样的事情...
select
first_date,second_date,case
when first_date > second_date
then
substring(datename(month,first_date),1,3) + '-' + substring(datename(year,3,2)
else
substring(datename(month,second_date),2)
end as result
from (
select CONVERT(datetime,'2017-08-25') as first_date,CONVERT(datetime,'2017-02-02') as second_date
union
select CONVERT(datetime,'2018-01-25') as first_date,'2018-12-04') as second_date
union
select CONVERT(datetime,'2019-11-14') as first_date,'2019-11-14') as second_date
) x;
;
,
假设您的日期列确实为date
,那么您似乎正在寻找:
select format(coalesce(start_date_1,start_date_2),'MMM-yy')
from t;