/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

1 vote309 views1 answer
Column with prefix in sql
SQL
0 vote321 views1 answer
Varchar format not case sensitive sql
SQL
1 vote330 views1 answer
Table infromation in sql server
SQL
1 vote354 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote351 views1 answer
Command to give readonly access to a postgres sql user
SQL
7 votes331 views2 answers
Execute mysql file
SQL
1 vote337 views1 answer
Add many column to sap iq table
SQL
0 vote341 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote321 views1 answer
Oracle list proxy users
SQL
0 vote303 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL