jConnect 7.0 and the Adaptive Server ODBC Driver, OLE DB Provider, and ADO.NET Data Provider 2.155 provide 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, jConnect 7.0 for JDBC and the Adaptive Server ODBC Driver, OLE DB Provider, and ADO.NET Data Provider 2.155 transfer 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 drivers and data providers 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, jConnect 7.0 and the Adaptive Server ODBC Driver, OLE DB Provider, and ADO.NET Data Provider 2.155 transfer data using the datetime and time datatypes.
jConnect 6.05 and Adaptive Server ODBC Driver 15.0, OLE DB Provider 15.0, and ADO.NET Data Provider 1.15 use datetime and time datatypes when connecting to Adaptive Server 15.5.
