Do you use TIME and TIMESTAMP in your applications? The new IBProvider version will further simplify your work!

Have you ever lost microseconds when working with the type TIME? Definitely, if you have ever tried to use them. In the previous versions of IBProvider, time was stored in OLE DB structure of DBTYPE_DBTIME type that does not support fractions of a second.

In the new IBProvider version, time data types have been improved. The new properties dbtime_rules and dbtimestamp_rules allow to set time storage not only in DBTIME/DBTIMESTAMP but also in WSTR and in the new type of MS SQL 2008 — DBTIME2 without losing milliseconds.

TIME data type

The initialization property dbtime_rules defining the rules for TIME columns was added. Now you can obtain TIME data as DBTIME, DBTIME2 or WSTR. DBTIME2 and WSTR modes exclude losing of microseconds.

BSTR type is used as a VARIANT compatible type for DBTIME/DBTIME2 columns, similarly to SQLNCLI.

TIMESTAMP data type

The initialization property dbtimestamp_rules defining the rules for TIMESTAMP columns was added. Now you can obtain TIMESTAMP data as DBTIMESTAMP or WSTR.

Additionally:

Corrected were small errors in the implementation of IColumnsRowset for columns with arrays.

Result: