From: Atli T. <at...@ga...> - 2004-05-27 17:51:11
|
Hi, I am dealing with an inconsistency between replies from db2. The following comparison works fine using db2 command line select ... from ... where a.time >= CURRENT TIMESTAMP - '3 hours' but when using pydb2 I get: SQLSTATE : 42818, NATIVE ERROR CODE : -401 [IBM][CLI Driver][DB2/6000] SQL0401N The data types of the operands for the operation ">=" are not compatible. SQLSTATE=42818 Any ideas? Atli Thorbjornsson. |