To get the start date of the last 4 quarters in OBIEE Answers
TIMESTAMPADD(SQL_TSI_QUARTER, -3, TIMESTAMPADD( SQL_TSI_DAY,-1*(DAY_OF_QUARTER(CURRENT_DATE)-1), CURRENT_DATE ) )
Wednesday, May 19, 2010
OBIEE Datetime Functions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment