/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 vote136 views2 answers
How to save result of sqlite query in a table
SQL
0 vote149 views2 answers
Reseed sql identity
SQL
1 vote134 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote139 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote128 views2 answers
Starting mysql service from mac
SQL
0 vote144 views1 answer
Delete hangfire retries list
SQL
0 vote169 views1 answer
For select oracle
SQL
0 vote180 views1 answer
Parent and child link in mysql
SQL
0 vote126 views1 answer
Mysql isshow
SQL
0 vote132 views1 answer
Insert set mysql
SQL