OTBI Prompt - Last Day of the Previous Month 23:59:59

Question

Hi all,

Hope you are keeping well.

So far, within a Prompt we are using the following code and this does indeed bring back the Last Day of the Previous Month successfully:

SELECT TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

FROM "Workforce Management - Historical Processed Time Cards Real Time"

Can this be extended so this also includes the time of 23:59:59 (Currently, this remains as 12:00:00).

Kind regards,

David

David Oldfield · Answer

Hi Rajasekhar,

I am unsure if I am doing something incorrectly here - I attempted to change the time element on both of the prompts to 23:59:59

And below is the output incl. the logs output:

Logs Output:

I don't see where its attempting to include the time element of 23:59:59 ?

Kind regards,

David

Rajasekhar Bandaru-Oracle · Answer

Hi David

From NQSQuery.log, Please review the physical Query generated for the Prompt and review the logic used.

David Oldfield · Answer

Hi Rajasekhar,

Apologies, I have been unable to get the updated logic in order to add the time element of 23:59:59.

Kind regards,

David