ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-19
Timestamp Values with Fraction
If a value of the SQL fraction precision property is set to 9 using the SQL Fraction
Precision Value: drop-down list and when a timestamp struct value is retrieved using
a C/C++ program from a column with type time or timestamp, the fraction field in the
timestamp struct is considered in nanoseconds.
Table 5-23 lists the sample values that can be retrieved using a C/C++ program from
the required column type and their corresponding expected values in nanosecond.
0.000654 timestamp(6) or time(6) 654
0.000054 timestamp(6) or time(6) 54
0.000004 timestamp(6) or time(6) 4
0.98765 timestamp(5) or time(5) 98765
0.08765 timestamp(5) or time(5) 8765
0.00765 timestamp(5) or time(5) 765
0.00065 timestamp(5) or time(5) 65
0.00005 timestamp(5) or time(5) 5
0.00000 timestamp(5) or time(5) 0
0.9876 timestamp(4) or time(4) 9876
0.0876 timestamp(4) or time(4) 876
0.0076 timestamp(4) or time(4) 76
0.0007 timestamp(4) or time(4) 7
0.0000 timestamp(4) or time(4) 0
0.987 timestamp(3) or time(3) 987
0.087 timestamp(3) or time(3) 87
0.008 timestamp(3) or time(3) 8
0.000 timestamp(3) or time(3) 0
0.98 timestamp(2) or time(2) 98
0.09 timestamp(2) or time(2) 9
0.00 timestamp(2) or time(2) 0
0.9 timestamp(1) or time(1) 9
0.0 timestamp(1) or time(1) 0
Table 5-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program
Value in the Column of the
SQL/MX Table Column Type
Value in the Fraction of
the Client Program