|
lleonard -> Truncation of datetime in odbc (5 May 2005)
|
Hi everyone,
We are using the Database Adapter to access a DB2 database through ODBC. One of the actions that we are performing is querying the database and getting a datetime value. For some reason, the fractional seconds part of the datetime value is truncated when it arrives at BizTalk.
I've done the following tests:
* Querying the database through the same driver (ODBC) from a custom C# application, the value is not truncated.
The value returned to my application is "2005-02-02 09:48:45.315217"
* I've activated the "Archive" feature of the receive location in the database adapter that I use to retrieve the values from the database.
The value logged for the same record through this feature is "2005-02-02T09:48:45.3150000+01:00"
Anyone an idea of which could be the reason for this behaviour?
Thanks in advance.
|
|
|
|
