/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 vote575 views2 answers
Sql unique rows
SQL
0 vote353 views1 answer
Python mysql executemany
SQL
0 vote350 views1 answer
Sql beginning of previous month
SQL
0 vote305 views1 answer
Online sql compiler
SQL
5 votes366 views4 answers
Mysql on duplicate key update
SQL
0 vote366 views1 answer
Get first 3 letter of department name in sql
SQL
4 votes426 views4 answers
Mysql get date from datetime
SQL
0 vote353 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote349 views1 answer
What is mysql_pconnect
SQL
-1 vote345 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL