| Subject | RE: [firebird-support] Datatypes are not comparable in expression CASE when using TIMESTAMPS |
|---|---|
| Author | Maya Opperman |
| Post date | 2013-08-13T04:41:46Z |
>Mark Rotteveel wrote:Make datefield a TIMESTAMP, not a DATE, and you should get the error as well.
>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
>);