从Oracle中的日期差计算年份 [英] Calculate year from date difference in Oracle

问题描述

我想计算两个日期之间的年数.

I want to calculate the number of years between two dates.

例如:-Select to_date('30-OCT-2013') - TO_date('30-SEP-2014') FROM DUAL;

这将导致335天.我想用几年来显示，这将是.97年.

This would result to 335 days. I want to show this in years, which will be .97 years.

推荐答案

只需执行此操作(除以 365.242199 ):

Simply do this(divide by 365.242199):

Select (to_date('30-SEPT-2014') - TO_date('30-OCT-2013'))/365.242199 FROM DUAL;

1年= 365.242199天

OR

使用 MONTHS_BETWEEN :-

select floor(months_between(date '2014-10-10', date '2013-10-10') /12) from dual;

或者您也可以尝试以下操作:-

or you may also try this:-

SELECT EXTRACT(YEAR FROM date1) - EXTRACT(YEAR FROM date2) FROM DUAL;

在旁注:-

On a side note:-

335/365.242199 = 0.917199603而不是.97

335/365.242199 = 0.917199603 and not .97

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