Help needed in SQLCODE -401.

[Seema Jain]

Hello all-

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.

[zprogrammer]

Try

Code: Select all

WHERE DATE(TIMESTAMP_COLUMN) > CURRENT DATE - 7 YEARS;

[Anuj Dhawan]

[mention]Seema Jain[/mention],

Please see this previous topic too: SQLCODE -401 in a Date calculation.

[Seema Jain]

Thanks all.

Code: Select all

WHERE DATE(TIMESTAMP_COLUMN) > CURRENT DATE - 7 YEARS;  

has worked.

[Anuj Dhawan]

Thanks for posting what has worked for you - appreciate that.