SQL每日一题(20220214)
SQL每日一题(20220321)
select *,
case
when t0901.类别 = '普通' then date_add(入职日期, interval 3 month)
else date_add(入职日期, interval 6 month) end as 转正日期,
case
when day(date(入职日期)) <= 15 then date_format(入职日期, '%Y-%m')
else date_format(DATE_ADD(入职日期, INTERVAL 1 MONTH), '%Y-%m') end as 社保缴纳月份
from t0901;