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

Table 22 Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values
in Microsecond (continued)
Expected Value in the Column of the
SQL/MX TableColumn Type
Value Specified in the Fraction of the
Client Program
0.00timestamp(2) or time(2)54
0.00timestamp(2) or time(2)4
0.9timestamp(1) or time(1)987654
0.0timestamp(1) or time(1)87654
0.0timestamp(1) or time(1)7654
0.0timestamp(1) or time(1)654
0.0timestamp(1) or time(1)54
0.0timestamp(1) or time(1)4
Table 23 Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values
in Nanosecond
Expected Value in Column of the
SQL/MX TableColumn Type
Value Specified in the Fraction of the
Client Program
0.987654timestamp(6) or time(6)987654321
0.087654timestamp(6) or time(6)87654321
0.007654timestamp(6) or time(6)7654321
0.000654timestamp(6) or time(6)654321
0.000054timestamp(6) or time(6)54321
0.000004timestamp(6) or time(6)4321
0.98765timestamp(5) or time(5)987654321
0.08765timestamp(5) or time(5)87654321
0.00765timestamp(5) or time(5)7654321
0.00065timestamp(5) or time(5)654321
0.00005timestamp(5) or time(5)54321
0.00000timestamp(5) or time(5)4321
0.9876timestamp(4) or time(4)987654321
0.0876timestamp(4) or time(4)87654321
0.0076timestamp(4) or time(4)7654321
0.0006timestamp(4) or time(4)654321
0.0000timestamp(4) or time(4)54321
0.0000timestamp(4) or time(4)4321
0.987timestamp(3) or time(3)987654321
0.087timestamp(3) or time(3)87654321
0.007timestamp(3) or time(3)7654321
0.000timestamp(3) or time(3)654321
0.000timestamp(3) or time(3)54321
Timestamp Values with Fraction 43