/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 vote111 views1 answer
Oracle table free space
SQL
1 vote102 views3 answers
How to filter repeated same result using sql query
SQL
1 vote114 views1 answer
Psql human readable
SQL
3 votes71 views1 answer
V$session not found in oracle
SQL
0 vote192 views1 answer
Restart serial number for postgres
SQL
0 vote114 views1 answer
Sql get month from date
SQL
1 vote113 views2 answers
Drop function in sql
SQL
0 vote122 views1 answer
Exit psql
SQL
1 vote121 views1 answer
Install postgresql on raspberry pi
SQL
10 votes122 views4 answers
Join with multiple conditions sql
SQL