/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 vote199 views1 answer
How to close external sql connection in laravel
SQL
0 vote191 views1 answer
Get last date join sql
SQL
2 votes146 views5 answers
Alter table primary key postgresql
SQL
0 vote190 views2 answers
How covert into int in maria db
SQL
3 votes202 views1 answer
Oracle list privileges
SQL
5 votes176 views1 answer
Oracle scan source ddl
SQL
8 votes212 views1 answer
Oracle current date plus 1 month
SQL
6 votes191 views1 answer
Oracle rank
SQL
1 vote183 views1 answer
Oracle avg
SQL
3 votes283 views3 answers
Mysql get table size
SQL