DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=12;AT YEAR YEARS MONTH MONTHS DAY DAYS HOUR HOURS MINUTE MINUTE

0
votes

I am trying to delete one of row using jdbc statement of my DB2 table but I am getting below Exception

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=12;AT YEAR YEARS MONTH MONTHS DAY DAYS HOUR HOURS MINUTE MINUTE

query is as follows

DELETE FROM DATA_TABLE WHERE ((PID_FROM = 'ABC123' AND PID = 'DEF456 ') OR (DEPT_FROM = '' AND DEPT_TO = ''))  AND  ST_FROM = 2022-07-28 12:44:37.464629428 AND ST_TO = 2022-07-28 12:44:37.464629428

Dataype of ST_FROM and ST_TO is Timestamp in DB2 table.

javajdbcdb2