Extra Pages

▼

Tuesday, December 9, 2008

OBIEE First / Last day previous week

First day of the previous week:

TIMESTAMPADD(SQL_TSI_DAY,-6, (TIMESTAMPADD(SQL_TSI_DAY, DAYOFWEEK(CURRENT_DATE) *-1,CURRENT_DATE)))

Last day of the previous week:

TIMESTAMPADD(SQL_TSI_DAY, DAYOFWEEK(CURRENT_DATE) *-1,CURRENT_DATE)

Till Next Time

at

2 comments:

  1. AnonymousMarch 25, 2010 at 9:19 AM

    Hi I need Last day of previous week in Oracle 10g

    Please help me

    ReplyDelete
  2. AnonymousMarch 29, 2010 at 7:29 AM

    Hi How to get previous 4 weeks+current week data in OBi?

    ReplyDelete

Note: Only a member of this blog may post a comment.