Truncation of datetime in odbc

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Truncation of datetime in odbc

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Truncation of datetime in odbc

Page: [1]

Message

<< Older Topic Newer Topic >>

Truncation of datetime in odbc - 5 May 2005

lleonard

Posts: 11
Score: 0
Joined: 5 May 2005
Status: offline

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.