Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle ADD_MONTHS function to HiRDB

SQLWays changes ADD_MONTHS function to expression with plus and adds specificator month to integer value.

Oracle:

select add_months(date_col1, 2) from t;  

HiRDB:

select date_col1+2 MONTH from t;  

References in Wiki

Database Reference
Oracle ADD_MONTHS

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.