Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Timestamp Values with Fraction
If a value of the SQLFractionValue property is not specified in the ODBCDSN file (or if it is equal
to SYSTEM_DEFAULT or another value different from 9) and when a timestamp struct value is
inserted from a C/C++ program into a column with type time or timestamp, the fraction field in
the timestamp struct is considered in microseconds. If SQLFractionValue property is equal to 9, the
timestamp struct is considered to be in nanoseconds.
Table 22 lists the sample values that can be inserted from a C/C++ program into the required
column type and their corresponding expected values in microsecond.
Table 22 Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values
in Microsecond
Expected Value in the Column of the
SQL/MX TableColumn Type
Value Specified in the Fraction of the
Client Program
0.987654timestamp(6) or time(6)987654
0.087654timestamp(6) or time(6)87654
0.007654timestamp(6) or time(6)7654
0.000654timestamp(6) or time(6)654
0.000054timestamp(6) or time(6)54
0.000004timestamp(6) or time(6)4
0.98765timestamp(5) or time(5)987654
0.08765timestamp(5) or time(5)87654
0.00765timestamp(5) or time(5)7654
0.00065timestamp(5) or time(5)654
0.00005timestamp(5) or time(5)54
0.00000timestamp(5) or time(5)4
0.9876timestamp(4) or time(4)987654
0.0876timestamp(4) or time(4)87654
0.0076timestamp(4) or time(4)7654
0.0006timestamp(4) or time(4)654
0.0000timestamp(4) or time(4)54
0.0000timestamp(4) or time(4)4
0.987timestamp(3) or time(3)987654
0.087timestamp(3) or time(3)87654
0.007timestamp(3) or time(3)7654
0.000timestamp(3) or time(3)654
0.000timestamp(3) or time(3)54
0.000timestamp(3) or time(3)4
0.98timestamp(2) or time(2)987654
0.08timestamp(2) or time(2)87654
0.00timestamp(2) or time(2)7654
0.00timestamp(2) or time(2)654
42 ODBC/MX Conformance