Oracle 日期差异以获取年数 [英] Oracle date difference to get number of years

问题描述

有没有办法计算日期之间的年数.不知道如何做到这一点，同时考虑到飞跃和什么不是.是否可以在 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.

这篇关于Oracle 日期差异以获取年数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！