ODBC & TIMESTAMPADD Function (Error 7498)

[trc_pdx]

V10.1B3

SELECT { fn TIMESTAMPADD('SQL_TSI_YEAR', 1, "transdt") } AS EXPR1
FROM some-table

Yields this error:

Runtime Error: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Error in row.
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Invalid number string (7498)

Just trying to figure out how to do some date math. What am I missing?

 

[Casper]

Seems like a bug to me. I get the same results in 10.2A01. But it might be that I am missing something too...

Casper.

 

[trc_pdx]

Seems like a bug to me.
Casper.

I was hoping it wouldn't come to that. I wonder if anybody else is able to perform date math like this ...

 

[Casper]

I think this is a nice one for TS.
The error indicates that there is some kind of data type conversion going on. I used a date and datetime field as input. Datetime-tz gives "inconsistent types" error.

Casper.