Dates conversion

[Kido]

If I want to get the number of days between two dates say 01/01/1995 and 26/12/2000, it is simply
(26/12/2000)- (01/01/1995). Now the problem is converting the days into years. Any idea?

 

[sem]

You may use MONTHS_BETWEEN function and divide the result by 12.

Regards, Dima

http://seminihin.narod.ru

 

[Kido]

That could work but its not accurate as it is assuming 31 days in a month.

 

[lewisp]

The official number of days in a year is 365.2525.

 

[sem]

Kido, why do you think so? It makes no "hardcoded" assumptions about month length:

SQL> select months_between(to_date('01.03.05','dd.mm.rr')
  2  ,to_date('01.02.05','dd.mm.rr')) month,
  3  to_date('01.03.05','dd.mm.rr')
  4  -to_date('01.02.05','dd.mm.rr') days
  5  from dual;

     MONTH       DAYS
---------- ----------
         1         28

Regards, Dima

http://seminihin.narod.ru