Converting SQL timestamp to DB2....anyone with any

[jcash35010]

suggestions? I have the timestamp from SQL which I need to convert to enter into DB2 format timestamp. Does anyone know how to do this? I've tried several different things, and so far nothing works...

any help is greatly appreciated!

 

[nigelrivett]

Is this a timestamp or datetime?
If it's a timestamp (or rowversion) then it's just dependent on the tr log entries and is binary(8).

If it's a datetime you may have to convert. Be cautious about the accuracy of the db2 dtatype compared to the sql server version.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jcash35010]

Its datetime, and I am not sure as to how to convert it.

 

[jcash35010]

I found a way to convert it. In my vb code in the SQL statement to insert or update the DB2 table I use
timestamp_format(SQLdatefield, 'YYYY-MM-DD HH24:MI:SS').

example:
timestamp_format('2003-10-28 10:52:01','YYYY-MM-DD HH24:MI:SS')