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

Table 13 Values retrieved by the application for SYSTEM_DEFAULT setting (continued)
Fraction value retrieved by the
application
Column type
Value in the column of the SQL/MX
Table
9876 timestamp(4) or time(4) 0.9876
876 timestamp(4) or time(4) 0.0876
76 timestamp(4) or time(4) 0.0076
7 timestamp(4) or time(4) 0.0007
0 timestamp(4) or time(4) 0.0000
987 timestamp(3) or time(3) 0.987
87 timestamp(3) or time(3) 0.087
8 timestamp(3) or time(3) 0.008
0 timestamp(3) or time(3) 0.000
98 timestamp(2) or time(2) 0.98
9 timestamp(2) or time(2) 0.09
0 timestamp(2) or time(2) 0.00
9 timestamp(1) or time(1) 0.9
0 timestamp(1) or time(1) 0.0
Table 14 includes a set of sample values retrieved by the application when SQLFractionValue is
9. The values are in nanoseconds.
Table 14 Sample values retrieved by the application
Fraction value retrieved by the
application
Column type
Value in the column of the SQL/MX
Table
987654000 timestamp(6) or time(6) 0.987654
87654000 timestamp(6) or time(6) 0.087654
7654000 timestamp(6) or time(6) 0.007654
654000 timestamp(6) or time(6) 0.000654
54000 timestamp(6) or time(6) 0.000054
4000 timestamp(6) or time(6) 0.000004
987650000 timestamp(5) or time(5) 0.98765
87650000 timestamp(5) or time(5) 0.08765
7650000 timestamp(5) or time(5) 0.00765
650000 timestamp(5) or time(5) 0.00065
60000 timestamp(5) or time(5) 0.00006
0 timestamp(5) or time(5) 0.00000
987600000 timestamp(4) or time(4) 0.9876
87600000 timestamp(4) or time(4) 0.0876
7600000 timestamp(4) or time(4) 0.0076
700000 timestamp(4) or time(4) 0.0007
0 timestamp(4) or time(4) 0.0000
Timestamp values with fraction 45