/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

2 votes346 views1 answer
Sql skip the first row
SQL
0 vote348 views1 answer
Oracle enable chain
SQL
2 votes417 views1 answer
Sql find not in list
SQL
2 votes377 views5 answers
Install postgresql 10 centos 7
SQL
21 votes390 views5 answers
Oracle all tables
SQL
1 vote354 views1 answer
Sql how to duplicate a table
SQL
9 votes345 views3 answers
Oracle undo usage by session
SQL
1 vote353 views1 answer
Oracle list data files
SQL
2 votes343 views1 answer
Brew start postgres manual
SQL
1 vote338 views1 answer
Mysql f# examples
SQL