0

I have been using the SQL_INTERVAL_STRUCT to fetch Interval data from an Informix database. I have discovered that the fractional part of the Interval is expected to be in microseconds (rather than milliseconds).

Can anyone confirm if this is Informix specific behavior or if all ODBC drivers would make this same assumption about the fraction portion of an Interval.

Here is the definition of the struct: http://msdn.microsoft.com/en-us/library/ms711781(v=vs.85).aspx

David Ritter
  • 110
  • 9

1 Answers1

0

I cant find a definitive answer, but it seems likely given that the fractional part of a SQL_TIMESTAMP_STRUCT is defined as being in microseconds (10e-9 sec).

But I agree, it seems strangely undefined. You can of course set the fractional precision in the data type, but that doesn’t alter the C structure representation. Or at least its not likely that it would, if the timestamp example is any guide.

Nick Gorham
  • 1,118
  • 8
  • 9