DB2 Timestamp with MS Access 2000

R

Rene

Hi
I'm looking for a solution regarding the problem with the
DB2 timestamp format in MS Access. I have to access DB2
tables on an mainframe computer through ODBC (IBM
Version) and export the data into MS Access.

MS Access displays the timestamp information like this:
09.10.2003 21:38:26

What I need is the format of the original DB2 timestamp:
2003-10-09-17.28.49.223826

I have tried different stuff but I cannot bring the
timestamp in the format I need.

There must be people who had the same problem!

Regards
Rene
 
Top