How to subtract 30 days from the current datetime in SAP HANA code example
Example: hana date add
SELECT ADD_DAYS (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), 30) "add 30 days" FROM DUMMY;
SELECT ADD_DAYS (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), 30) "add 30 days" FROM DUMMY;