Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

first day of second quarter of previous year in OBIEE

Received Response
11
Views
2
Comments
3603435
3603435 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

Can someone help in writing first day of second quarter of previous year..or at least first day of second quarter for current year timestamp function in OBIEE

Thanks

Surabhi

Answers

  • Mohammed Sulaiman
    Mohammed Sulaiman Rank 1 - Community Starter

    Hi Surabhi,

    Below i have given some piece of code which is used to get first day of the second quarter. Here you by replacing the year to get the day as well.

    TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( TIMESTAMP'2017-05-27 00:00:00') * -(1) + 1, TIMESTAMP'2017-05-27 00:00:00')

    Thanks

    Sulaiman

  • 3603435
    3603435 Rank 1 - Community Starter

    Thanks So much Sulaiman..It really helped.