unknown fieldtype while accessing DB2 Express C
lazarus / 16-Databases

----------------------------------------------------------------------
kordoba · 2006-05-14 16:30

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 · 2006-05-16 17:55

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 · 2006-05-16 21:38

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