Oracle PL/SQL Functionality Enhancement
Budget: £10 – £20 GBP
Require the below Oracle PL/SQL code to be updated to also include the time element of 23:59:59
SELECT TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
FROM X
(Code should display the last day of the previous month at 23:59:59)
SELECT TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
FROM X
(Code should display the last day of the previous month at 23:59:59)