I am using the following query: Please suggest how to correct it ?
Code: Select all
SELECT * FROM TABLEN
some conditions
WHERE timestamp_column > CURRENT DATE - 7 YEARS;
I am simply trying to get the data of 7 years from current date. But it ends in SQLCODE -401.
Thank you.