Wednesday, April 19, 2017

OBIEE QUERY FOR YESTERDAY'S DATE

  • Use the below code to get yesterday's Date in obiee.
  • Place this code in SQL results tab of OBIEE Prompt. 
 

SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE) FROM "Time"
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)