Hi,
I am trying to get Last Quarter date usnig ADD_MONTHS function as below.
Sql Query:
SELECT DATE_VALUE,
ADD_MONTHS(DATE_VALUE,-3) QUARTER_AGO_DATE
FROM
(
SELECT
TO_DATE('29-NOV-2017', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
UNION ALL
SELECT
TO_DATE('30-NOV-2017', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
UNION ALL
SELECT
TO_DATE('29-NOV-2018', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
UNION ALL
SELECT
TO_DATE('30-NOV-2018', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
UNION ALL
SELECT
TO_DATE('29-NOV-2019', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
UNION ALL
SELECT
TO_DATE('30-NOV-2019', 'DD-MON-YYYY') AS DATE_VALUE
FROM DUAL
);
Result:
In above result "30-Aug" record is missing. But i need to show "30-Aug" record insted of "31-Aug" record.