List of user accounts in MySQL using the command line?

Which date function is used to find the difference between two dates in Oracle?

Which date function is used to find the difference between two dates in Oracle?

we have to use months_between date function which returns the float value.

Sql>select months_between('07-jun-2007','02-jun-2006') from dual;

to get results in the integer use the round function with it.

sql>select round(months_between('07-jun-2007','02-jun-2006')) from dual;