[unixODBC-support] SQL_INTERVAL_STRUCT fraction portion

Nick Gorham nick at lurcher.org
Mon Apr 14 09:50:06 BST 2014

On 13/04/14 23:27, David Ritter wrote:
> Hello,
> 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 about all the definition of the struct that I can find:
> http://msdn.microsoft.com/en-us/library/ms711781(v=vs.85).aspx 
> <http://msdn.microsoft.com/en-us/library/ms711781%28v=vs.85%29.aspx>
> Thank you for your help,
> David Ritter

It does seem a little bit undefined, but microseconds (10e-9) would be 
consistent with the fractional part of the SQL_TIMESTAMP_STRUCTURE where 
it is clearly defined.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20140414/0e1edfda/attachment.html>

More information about the unixODBC-support mailing list