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

Table 11 Sample values inserted from an application and expected values in microsecond (continued)
Expected value in the column of
SQL/MX table
Column type Fraction value in the application
0.000 timestamp(3) or time(3) 54
0.000 timestamp(3) or time(3) 4
0.98 timestamp(2) or time(2) 987654
0.08 timestamp(2) or time(2) 87654
0.00 timestamp(2) or time(2) 7654
0.00 timestamp(2) or time(2) 654
0.00 timestamp(2) or time(2) 54
0.00 timestamp(2) or time(2) 4
0.9 timestamp(1) or time(1) 987654
0.0 timestamp(1) or time(1) 87654
0.0 timestamp(1) or time(1) 7654
0.0 timestamp(1) or time(1) 654
0.0 timestamp(1) or time(1) 54
0.0 timestamp(1) or time(1) 4
Table 12 includes a set of sample values and expected values in the column of an SQL/MX table
in nanoseconds.
Table 12 Sample values inserted from an application and expected values in nanoseconds
Expected value in the column of
SQL/MX table Column type Fraction value in the application
0.987654 timestamp(6) or time(6) 987654321
0.087654 timestamp(6) or time(6) 87654321
0.007654 timestamp(6) or time(6) 7654321
0.000654 timestamp(6) or time(6) 654321
0.000054 timestamp(6) or time(6) 54321
0.000004 timestamp(6) or time(6) 4321
0.98765 timestamp(5) or time(5) 987654321
0.08765 timestamp(5) or time(5) 87654321
0.00765 timestamp(5) or time(5) 7654321
0.00065 timestamp(5) or time(5) 654321
0.00005 timestamp(5) or time(5) 54321
0.00000 timestamp(5) or time(5) 4321
0.9876 timestamp(4) or time(4) 987654321
0.0876 timestamp(4) or time(4) 87654321
0.0076 timestamp(4) or time(4) 7654321
0.0006 timestamp(4) or time(4) 654321
0.0000 timestamp(4) or time(4) 54321
Timestamp values with fraction 43