Recent

Author Topic: unknown fieldtype while accessing DB2 Express C  (Read 2933 times)

kordoba

  • Guest
unknown fieldtype while accessing DB2 Express C
« on: May 14, 2006, 06:30:46 pm »
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

  • Administrator
  • Hero Member
  • *
  • Posts: 3541
RE: unknown fieldtype while accessing DB2 Express C
« Reply #1 on: May 16, 2006, 07:55:24 pm »
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

  • Guest
RE: unknown fieldtype while accessing DB2 Express C
« Reply #2 on: May 16, 2006, 11:38:34 pm »
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