Advertisement
lucasmouraahere

Função Oracle MONTHS BETWEEN

Jun 27th, 2019
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.46 KB | None | 0 0
  1. SELECT MONTHS_BETWEEN(TO_DATE('28/12/2017', 'DD/MM/YY'),
  2.                       TO_DATE('03/08/2017', 'DD/MM/YY')) AS MONTHS_BETWEEN
  3.  FROM dual;
  4.  
  5. SELECT TRUNC(MONTHS_BETWEEN(TO_DATE('28/12/2017', 'DD/MM/YY'),
  6.                             TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN
  7.  FROM dual;
  8.  
  9. SELECT ROUND(MONTHS_BETWEEN(TO_DATE('28/12/2017', 'DD/MM/YY'),
  10.                             TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN
  11.  FROM dual;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement