ODBC/MX Driver for Windows Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1—663858-001
5-20
Timestamp Values with Fraction
Table 5-23. Sample Values Retrieved Using a C/C++ Program and Their
Corresponding Expected Values in Nanosecond
Value in the Column of the
SQL/MX Table Column Type
Value in the Fraction of
the Client Program
0.987654 timestamp(6) or time(6) 987654000
0.087654 timestamp(6) or time(6) 87654000
0.007654 timestamp(6) or time(6) 7654000
0.000654 timestamp(6) or time(6) 654000
0.000054 timestamp(6) or time(6) 54000
0.000004 timestamp(6) or time(6) 4000
0.98765 timestamp(5) or time(5) 987650000
0.08765 timestamp(5) or time(5) 87650000
0.00765 timestamp(5) or time(5) 7650000
0.00065 timestamp(5) or time(5) 650000
0.00006 timestamp(5) or time(5) 60000
0.00000 timestamp(5) or time(5) 0
0.9876 timestamp(4) or time(4) 987600000
0.0876 timestamp(4) or time(4) 87600000
0.0076 timestamp(4) or time(4) 7600000
0.0007 timestamp(4) or time(4) 700000
0.0000 timestamp(4) or time(4) 0
0.987 timestamp(3) or time(3) 987000000
0.087 timestamp(3) or time(3) 87000000
0.008 timestamp(3) or time(3) 8000000
0.000 timestamp(3) or time(3) 0
0.98 timestamp(2) or time(2) 980000000
0.09 timestamp(2) or time(2) 90000000
0.00 timestamp(2) or time(2) 0
0.9 timestamp(1) or time(1) 900000000
0.0 timestamp(1) or time(1) 0