How to handle operators and dates

[jisoo23]

Hey everyone,

This is probably a very easy question but for the life of me I can't find any examples to get me past this. Here is my query:

Select * from schema.table where schema.table.TS_LOAD > TIMESTAMP('2005-11-22');

When executing, I get an error back that says:

[IBM][CLI Driver][DB2] SQL0180N  The syntax of the string representation of a datetime value is incorrect.  SQLSTATE=22007

The TS_LOAD column is of the timestamp datatype, so I'm not sure why I'm getting this error?

Thanks in advance,
Jisoo23

 

[juliane26]

you have to use:
TIMESTAMP('2005-11-23-00.00.00.000000')

try:

Select * from schema.table where table.TS_LOAD > TIMESTAMP('2005-11-23-00.00.00.000000');

Juliane

 

[jrohrbach]

A second solution is to get the date portion of the column value and compare it to your value:

Select * from schema.table where DATE(table.TS_LOAD) > '2005-11-23';

Ever onward,
jar

 

[jisoo23]

Finally figured it out early this morning. I used this way:

select * from schema.table where table.TS_LOAD > TIMESTAMP('20051122000000');
{/code]

Thanks for the help!