datetime field precision not available

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Alexei Karas Thu, 18 Jan 2001 14:52

#5940

Author: Alexei Karas
Date: Thu, 18 Jan 2001 14:52

14 lines
1474 bytes

While working with Informix database through OLE DB Provider for ODBC, I
can't get figures for tenth part of second for the field declared as
"TimeStamp datetime year to fraction(4)" i.e. I have four digits after
decimal point for seconds. When I execute
?rsExpData.Fields("timestamp").Value
I get
07/01/2001 23:38:10
value. But field in DB actually contains "07/01/2001 23:38:09.5678" value.
When I query the same field through the same DSN with MS Query, for example,
I get correct  "07/01/2001 23:38:09.5678" value. May someone say what's
wrong, or that's OLE DB Provider's bug?

Sincerely,
      Alexei

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads