>Mark Rotteveel wrote: >I am unable to reproduce it. Could you create a simple reproduction script >that creates the table, adds the testdata and includes the query?
>My reproduction is: >CREATE TABLE int_date_table >( > intfield INTEGER, > datefield DATE, > timestampfield TIMESTAMP >); Make datefield a TIMESTAMP, not a DATE, and you should get the error as well.