Oracle 日期差异以获取年数

2021-12-06 00:00:00 select oracle

有没有办法计算日期之间的年数.不知道如何做到这一点，同时考虑到飞跃和什么不是.是否可以在 SELECT 中执行 IF 语句?

Is there a way to calculate the number of years between dates. Not sure how to do this while accounting for leap and what not. Is it possible to do an IF statement maybe in the SELECT?

谢谢

推荐答案

我会使用 months_between，可能与 floor 结合使用:

I'd use months_between, possibly combined with floor:

select floor(months_between(date '2012-10-10', date '2011-10-10') /12) from dual; select floor(months_between(date '2012-10-9' , date '2011-10-10') /12) from dual;

floor 确保您获得四舍五入的年份.如果你想要小数部分，你显然不想使用floor.

floor makes sure you get down-rounded years. If you want the fractional parts, you obviously want to not use floor.

相关文章