Hi Team,
I need the query that must return the data of older than one month .
Means whenever i execute the query (today , tomorrow, yesterday ... ) , the query should give me result of older than one month .
Is the following query is correct !!
CREATE TABLE DATE_CHECK
(
VAL NUMBER,
DT DATE
)
SELECT * FROM
DATE_CHECK
WHERE TRUNC(dt) < TRUNC(SYSDATE-30)
Please suggest is this correct , I tried with Sample data , It is coming as expected . I just wanted your suggestions