HP Integrity NonStop H-Series - Manual (Page 44)

Table 12 Sample values inserted from an application and expected values in nanoseconds (continued)
Expected value in the column of
SQL/MX table Column type Fraction value in the application
0.0000 timestamp(4) or time(4) 4321
0.987 timestamp(3) or time(3) 987654321
0.087 timestamp(3) or time(3) 87654321
0.007 timestamp(3) or time(3) 7654321
0.000 timestamp(3) or time(3) 654321
0.000 timestamp(3) or time(3) 54321
0.000 timestamp(3) or time(3) 4321
0.98 timestamp(2) or time(2) 987654321
0.08 timestamp(2) or time(2) 87654321
0.00 timestamp(2) or time(2) 7654321
0.00 timestamp(2) or time(2) 654321
0.00 timestamp(2) or time(2) 54321
0.00 timestamp(2) or time(2) 4321
0.9 timestamp(1) or time(1) 987654321
0.0 timestamp(1) or time(1) 87654321
0.0 timestamp(1) or time(1) 7654321
0.0 timestamp(1) or time(1) 654321
0.0 timestamp(1) or time(1) 54321
0.0 timestamp(1) or time(1) 4321
Table 13 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 13 Values retrieved by the application for SYSTEM_DEFAULT setting
Fraction value retrieved by the
application
Column type
Value in the column of the SQL/MX
Table
987654 timestamp(6) or time(6) 0.987654
87654 timestamp(6) or time(6) 0.087654
7654 timestamp(6) or time(6) 0.007654
654 timestamp(6) or time(6) 0.000654
54 timestamp(6) or time(6) 0.000054
4 timestamp(6) or time(6) 0.000004
98765 timestamp(5) or time(5) 0.98765
8765 timestamp(5) or time(5) 0.08765
765 timestamp(5) or time(5) 0.00765
65 timestamp(5) or time(5) 0.00065
5 timestamp(5) or time(5) 0.00005
0 timestamp(5) or time(5) 0.00000
44 Compatibility and considerations