Hi all,

I have a DB2 query (through an ODBC connection) trying to
pump into a table. Does anyone know what the target side
data type should be for a DB2 TIMESTAMP? I've tried
datetime and smalldatetime?

Thanks,

Mark

Have you tried extracting it as an varchar value and then converting it?

Jim

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote

well... that would work, but the datatype difference from timestamp
to datetime will still error on you. sql will of course import any thing
under varchar. getting the value into datetime still poses a problem,
and sql will hit you with the same error.

sql does not interpret the db2 'timestamp' format. it's a real pain.

i too am looking for a solution to it.

cheers