First Day of the Previous Year TIMESTAMPADD( SQL_TSI_YEAR , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))  From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD removes a year from the returned date for the First Day of the Previous Year. First Day of the Current Year TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( … Continue reading TIMESTAMP Expression for Date Calculation in OBIEE 11g/12c