ODBC/MX Driver for Windows Manual (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—640329-001
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.
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
0.987654 timestamp(6) or time(6) 987654
0.087654 timestamp(6) or time(6) 87654
0.007654 timestamp(6) or time(6) 7654
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