Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
3-18
Timestamp Values with Fraction
If a value of the SQLFractionValue property is equal to 9 in the ODBCDSN file 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 3-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.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 3-23. Sample Values Retrieved Using a C/C++ Program and Their
Corresponding Expected Values in Nanosecond (page 1 of 2)
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
Table 3-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++
Program (page 2 of 2)
Value in the Column of the
SQL/MX Table Column Type
Value in the Fraction of
the Client Program