A collection of OBIEE / OBISE stuff from 101 till 404. I just put the things here I run into.
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
Hi I need Last day of previous week in Oracle 10gPlease help me
Hi How to get previous 4 weeks+current week data in OBi?
Post a Comment
2 comments:
Hi I need Last day of previous week in Oracle 10g
Please help me
Hi How to get previous 4 weeks+current week data in OBi?
Post a Comment