Hive月份计算

最新推荐文章于 2024-08-30 10:39:39 发布

你锋哥真的强

最新推荐文章于 2024-08-30 10:39:39 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/q954103/article/details/103044501

select concat(split(months_between('2019-03-31','2018-02-01')/12,"\\.")[0],"年零",round(months_between('2019-03-31','2018-02-15')%12,1),"个月");
-- 1年零1.5个月

select concat(split(months_between('2019-03-31','2018-02-01')/12,"\\.")[0],"年零",round(months_between('2019-03-31','2018-02-01')%12,1),"个月");
-- 1年零2.0个月

select concat(split(months_between('2019-03-31','2018-02-28')/12,"\\.")[0],"年零",round(months_between('2019-03-31','2018-02-28')%12,1),"个月");
-- 1年零1.0个月