/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

7 votes233 views2 answers
Get database size mysql
SQL
1 vote245 views1 answer
Sysdate in sql
SQL
16 votes246 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote234 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
1 vote219 views2 answers
Difference between in and between in sql
SQL
8 votes255 views1 answer
Ltrim sql
SQL
34 votes233 views6 answers
Sql change data type
SQL
0 vote252 views1 answer
How to write if case in select query in select statement
SQL
-1 vote253 views1 answer
Create view in mysql workbench
SQL
0 vote242 views1 answer
Oracle last connexion
SQL