Mainframe, MVS and zOS Discussion

Posted: **Sat Sep 26, 2015 8:50 am**

Hi,

I am using a query for date calculation in my COBOL Program. The query is like this:

SELECT * FROM TABLENAME 
WHERE AKSTAMP >= CURRENT DATE - 3 YEARS;

where AKSTAP has the format like: 2015-09-15-01.13.32.563275

Could any one suggest how to correct the query, as I get SQLCODE -401 with above query.

Thanks in advance.

Posted: **Sat Sep 26, 2015 12:08 pm**

AKSTAMP is a timestamp field you need to equate to a date field ,Hence try the query below

Code: Select all

SELECT * FROM TABLENAME 
WHERE DATE(AKSTAMP) >= CURRENT DATE - 3 YEARS;

Mainframe, MVS and zOS Discussion

SQLCODE -401 in a Date calculation.

SQLCODE -401 in a Date calculation.

Re: SQLCODE -401 in a Date calculation.