Mainframe, MVS and zOS Discussion

Posted: **Mon Jan 04, 2016 4:26 pm**

Hello all-

I am using the following query: Please suggest how to correct it ?

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.

Posted: **Mon Jan 04, 2016 4:34 pm**

Try

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

Posted: **Mon Jan 04, 2016 4:44 pm**

[mention]Seema Jain[/mention],

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

Posted: **Tue Feb 09, 2016 12:04 pm**

Thanks all.

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

has worked.

Posted: **Sat Feb 20, 2016 6:27 pm**

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

Help needed in SQLCODE -401.