Re: [PyDB2-discuss] inconsistency

[<yu...@ad...>]

Quoting Atli Thorbjornsson <at...@ga...>:

> 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.
I'm assuming that a.time is defined to be of type timestamp, right ?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/