A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Pages
▼
Saturday, 13 April 2013
SQL Functions: MONTHS_BETWEEN
MONTHS_BETWEEN
Returns the number
of months between two date values. The return value can be negative or positive
depending on
SelectMONTHS_BETWEEN
(end_date,start_date) from emp;
No comments:
Post a Comment