ETL postgresql 加减月份，在postgresql中实现period_diff/month_diff

最新推荐文章于 2024-03-22 17:42:24 发布

原创最新推荐文章于 2024-03-22 17:42:24 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #postgresql

sql 专栏收录该内容

5 篇文章

订阅专栏

本文深入探讨了使用SQL从两个日期中提取年份和月份差值的方法，通过CASE WHEN语句实现对不同时间跨度的精确判断，适用于人员年龄或时间段的精确计算。

case when extract(year from age(b.statdt , a.statdt) ) = 1 and
extract(month from age(b.statdt , a.statdt) ) = 0 then 1 else 0 end Mon12,
case when extract(year from age(b.statdt , a.statdt) ) = 0 and
extract(month from age(b.statdt , a.statdt) ) = 0 then 1 else 0 end Mon0,
case when extract(month from age(b.statdt , a.statdt) ) = 1 then 1 else 0 end Mon1,
case when extract(month from age(b.statdt , a.statdt) ) = 2 then 1 else 0 end Mon2,
case when extract(month from age(b.statdt , a.statdt) ) = 3 then 1 else 0 end Mon3,
case when extract(month from age(b.statdt , a.statdt) ) = 4 then 1 else 0 end Mon4,
case when extract(month from age(b.statdt , a.statdt) ) = 5 then 1 else 0 end Mon5,
case when extract(month from age(b.statdt , a.statdt) ) = 6 then 1 else 0 end Mon6,
case when extract(month from age(b.statdt , a.statdt) ) = 7 then 1 else 0 end Mon7,
case when extract(month from age(b.statdt , a.statdt) ) = 8 then 1 else 0 end Mon8,
case when extract(month from age(b.statdt , a.statdt) ) = 9 then 1 else 0 end Mon9,
case when extract(month from age(b.statdt , a.statdt) ) = 10 then 1 else 0 end Mon10,
case when extract(month from age(b.statdt , a.statdt) ) = 11 then 1 else 0 end Mon11