/SQL/Oracle difference between two dates in years

Oracle difference between two dates in years

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;

Source: stackoverflow.com

Similar codes

0 vote159 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote168 views1 answer
Group by max date
SQL
3 votes143 views4 answers
Stop MySQL
SQL
3 votes163 views2 answers
Mysql select database
SQL
10 votes150 views5 answers
Between keyword in sql
SQL
1 vote156 views1 answer
Sql server update column based on another table
SQL
0 vote159 views1 answer
Sql getdate minus 1 day without time
SQL
8 votes156 views1 answer
Mysql limit rows
SQL
10 votes154 views2 answers
SQL rounding numbers
SQL
2 votes245 views1 answer
Sql ends with string
SQL