/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 vote170 views2 answers
Azure sql-datenbank
SQL
0 vote146 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
10 votes182 views1 answer
Query to find object dependencies in oracle
SQL
1 vote201 views1 answer
Get current date in pyspark sql
SQL
0 vote199 views1 answer
Mysql select all where count more than"
SQL
3 votes167 views2 answers
Mysql create database
SQL
0 vote186 views1 answer
Sql search all columns of database oracle sql
SQL
11 votes217 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
-1 vote212 views1 answer
Mysql faster insert
SQL
9 votes217 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL