/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 vote123 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
8 votes219 views1 answer
Mac restore mysql database command line
SQL
3 votes180 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
11 votes193 views5 answers
Laravel db facade
SQL
0 vote171 views1 answer
Sql server set complex constraints
SQL
10 votes175 views1 answer
Query to find object dependencies in oracle
SQL
23 votes222 views2 answers
Query to delete a database in mysql
SQL
9 votes225 views3 answers
Postgres make sql dump
SQL
0 vote252 views1 answer
DATEDIFF minute postgres
SQL
2 votes170 views2 answers
Mysql user access to database
SQL