From: Atli T. <at...@ga...> - 2004-05-28 15:32:00
|
I am porting an ingres application over to db2, hence the strange syntax. Extra quotes do not help but as I said removing them does. I can live wit= h that fix myself but I was just wondering why it works in command line db2 and not in pydb2. Atli. -----Original Message----- From: yu...@ad... [mailto:yu...@ad...] Sent: 28. ma=ED 2004 15:11 To: at...@ga... Cc: pyd...@li... Subject: RE: [PyDB2-discuss] inconsistency Quoting Atli Thorbjornsson <at...@ga...>: > It seems to have something to do with having '3 hours' enclosed in quot= es. > If I remove the quotes then pydb2 works fine. Does that clarify? > Atli I dont understand... you simply write CURRENT TIMESTAMP - '3 hours' ? I mean '3 hours' as a string ? Cause if so, try to replace '3 hours' with ''3 hours'' but i dont think that's the case (I wasn't even aware that you could subtract timestamps in that manner) ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ |