The Adaptive Server OLE DB Provider provides microsecond-level precision for time data by supporting the SQL datatypes bigdatetime and bigtime.
bigdatetime and bigtime function similarly to and have the same data mappings as the SQL datetime and time datatypes:
bigdatetime corresponds to the Adaptive Server bigdatetime datatype and indicates the number of microseconds that have passed since January 1, 0000 0:00:00.000000. The range of legal bigdatetime values is from January 1, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999.
bigtime corresponds to the Adaptive Server bigtime datatype and indicates the number of microseconds that have passed since the beginning of the day. The range of legal bigtime values is from 00:00:00.000000 to 23:59:59.999999.
When connecting to Adaptive Server 15.5, the Adaptive Server OLE DB Provider transfers data using the bigdatetime and bigtime datatypes even if the receiving Adaptive Server columns are defined as datetime and time.
This means that Adaptive server may silently truncate the values from the Adaptive Server OLE DB Provider to fit Adaptive Server columns. For example, a bigtime value of 23:59:59.999999 is saved as 23:59:59.996 in an Adaptive Server column with datatype time.
When connecting to Adaptive Server 15.0.x and earlier, the Adaptive Server OLE DB Provider transfers data using the datetime and time datatypes.
Earlier versions of Adaptive Server OLE DB Provider continue to use the datetime and time datatypes.