Adaptive Server ODBC Driver 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 00: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 ODBC Driver 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 ODBC Driver to fit the 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 ODBC Driver transfers data using the datetime and time datatypes.