Function DescriptionWatch Full Movie Streaming Online and Download
Function MONTHS_BETWEEN returns the number of months between two dates.
Examples
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SELECT MONTHS_BETWEEN(TO_DATE(‘02.02.2010’,‘DD.MM.YYYY’),
TO_DATE(‘01.10.2010’,‘DD.MM.YYYY’))
FROM dual;
Result: -7,96774193548387
SELECT MONTHS_BETWEEN(TO_DATE(‘01.10.2010’,‘DD.MM.YYYY’),
TO_DATE(‘02.02.2010’,‘DD.MM.YYYY’))
FROM dual;
Result: 7,96774193548387
SELECT MONTHS_BETWEEN(TO_DATE(‘02.02.2010’,‘DD.MM.YYYY’),
TO_DATE(‘02.02.2010’,‘DD.MM.YYYY’))
FROM dual;
Result: 0
|