MX Release 3.2.1 (H06.26+, J06.15+)

Table 10 Sample values inserted from an application and expected values in microsecond (continued)

Expected value in the column of

SQL/MX tableColumn typeFraction value in the application

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

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 11 (page 28) includes a set of sample values and expected values in the column of an

SQL/MX table in nanoseconds.

Table 11 Sample values inserted from an application and expected values in nanoseconds

Expected value in the column of

SQL/MX table

Column typeFraction value in the application

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

28 Driver compatibility and considerations