Oracle 日期差异以获取年数
本文介绍了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.
这篇关于Oracle 日期差异以获取年数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，