Pages

▼

Pages - Menu

▼

Tuesday, May 4, 2010

How to get one year back date in obiee

Formula to get one year back date

TIMESTAMPADD(SQL_TSI_YEAR, -1, CURRENT_DATE)

Ex: current_date=05/01/2010 then we will get 05/01/2009
at

4 comments:

  1. Parameshwaran VenkataramanMay 20, 2010 at 4:44 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. AnonymousMay 26, 2010 at 8:27 AM

    Dear Saichand i have one small question fro u,here i am facing one problem ,that is when i open the page of dashboard it is taking more time due to lot of not need reports are running ,how can i spot them can u send me the solution to my email id
    please
    sreedharsiri1@gamil.com

    ReplyDelete
  3. AnonymousJune 2, 2010 at 8:24 AM

    TIMESTAMPADD(SQL_TSI_DATE, -365, CURRENT_DATE)

    ReplyDelete
  4. AnonymousJuly 4, 2011 at 7:29 AM

    Instaed of timestampadd we can use timestampdiff.
    TIMESTAMPDIFF(SQL_TSI_DATE, 1, CURRENT_DATE)

    ReplyDelete

.