MX Release 3.2 (H06.25+, J06.14+)

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

Expected value in the column of

SQL/MX table

Column typeFraction value in the application

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

0.000timestamp(3) or time(3)4321

0.98timestamp(2) or time(2)987654321

0.08timestamp(2) or time(2)87654321

0.00timestamp(2) or time(2)7654321

0.00timestamp(2) or time(2)654321

0.00timestamp(2) or time(2)54321

0.00timestamp(2) or time(2)4321

0.9timestamp(1) or time(1)987654321

0.0timestamp(1) or time(1)87654321

0.0timestamp(1) or time(1)7654321

0.0timestamp(1) or time(1)654321

0.0timestamp(1) or time(1)54321

0.0timestamp(1) or time(1)4321

Table 11 (page 29) includes a set of sample values retrieved by the application when

SQLFractionValue is set to SYSTEM_DEFAULT or to a value other than 9.

Table 11 Values retrieved by the application for SYSTEM_DEFAULT setting

Fraction value retrieved by the

applicationColumn type

Value in the column of the SQL/MX

Table

987654timestamp(6) or time(6)0.987654

87654timestamp(6) or time(6)0.087654

7654timestamp(6) or time(6)0.007654

654timestamp(6) or time(6)0.000654

54timestamp(6) or time(6)0.000054

4timestamp(6) or time(6)0.000004

98765timestamp(5) or time(5)0.98765

8765timestamp(5) or time(5)0.08765

765timestamp(5) or time(5)0.00765

65timestamp(5) or time(5)0.00065

5timestamp(5) or time(5)0.00005

0timestamp(5) or time(5)0.00000

Timestamp values with fraction 29