Error: converting data type DBTYPE_DBTIMESTAMP to datetime

[Lava]

I am trying to query a DB2 table from SQL using the follwonig statemet:

Select * from openquery(DB2C1,'Select * from DMA.V_FCD')

when I run above statement, I get:

Server: Msg 8114, Level 16, State 8, Line 1

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Thanks.
LS

[MAK]

http://www.schemamania.org/jkl/books.../8_qd_12_8.htm

http://www.dbforums.com/archives/t57754.html

[MAK]

try this

Select * from openquery(DB2C1,'Select COL1, DATE(TS_Column), TIME(TS_Column) from DMA.V_FCD')


Refer:
http://www.cs.ucla.edu/classes/winte...1/DB2Time.html

[skhanal]

When you pull data from different database, date time always pose a problem. So you have to convert the date to acceptable format in sql server.