Oracle to SAP HANA Date Conversions
Are you migrating your reports and dashboards from Oracle to SAP HANA? Below are some ready to use date conversion SQL formulas which would save your significant amount of time. Please note that I have considered Financial year from 1-April to 31 March for year calculations. Also, number of days Calculations are considered till previous day. 1) Current Financial year start e.g. 1-Apr-2017 ADD_MONTHS(ADD_DAYS(CURRENT_DATE, DAYOFYEAR(CURRENT_DATE) * -1 + 1), 3) 2) Previous Financial Year start ADD_YEARS(ADD_MONTHS(ADD_DAYS(CURRENT_DATE, DAYOFYEAR(CURRENT_DATE) * -1 + 1), 3), -1) 3) First date of current Month ADD_DAYS(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1)), 1) 4)First date of current Month Previous year Add_months(ADD_DAYS(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1)), 1), -12) 5)Number of days till date This Financial year DAYS_BETWEEN(ADD_MONTHS(ADD_DAYS(CURRENT_DATE, DAYOFYEA...