unknown fieldtype while accessing DB2 Express C

[kordoba]

Hello,

i'm accessing DB2 Express C via sqldb.
Generally It works, but i can't access timestamp fields.
The errormessage ist "Unknown field type".
How can i solve this problem?

[felipemdc]

Try searching the mailling list archives. On March 29 a thread about this topic was created. The answer has something to do with the timestamp format. The thread is huge, so it's best that you read it.

[Anonymous]

The easiest way seems to bo to cast the column in the SQL-Statement like follows:
select cast(changedate as char(27)) changedate from schemaname.tablename