Code Example Center: ORACLE - How calculate months to date type

Monday, January 22, 2018

ORACLE - How calculate months to date type

select sysdate, add_months( sysdate, -1 ) minus1, add_months( sysdate, 12 ) minus12 from dual

Output:

SYSDATE  MINUS1   MINUS12 
-------- -------- --------
22.01.18 22.12.17 22.01.19

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)