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-17
Timestamp Values with Fraction
If a value of the SQLFractionValue property is not specified in the ODBCDSN file (or if
it is equal to SYSTEM_DEFAULT or another value different from 9) and when a
timestamp struct value is retrieved using a C/C++ program from a column with type
time or timestamp, the fraction field selects the SYSTEM_DEFAULT values, which are
listed in Table 3-22.
654321 timestamp(2) or time(2) 0.00
54321 timestamp(2) or time(2) 0.00
4321 timestamp(2) or time(2) 0.00
987654321 timestamp(1) or time(1) 0.9
87654321 timestamp(1) or time(1) 0.0
7654321 timestamp(1) or time(1) 0.0
654321 timestamp(1) or time(1) 0.0
54321 timestamp(1) or time(1) 0.0
4321 timestamp(1) or time(1) 0.0
Table 3-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++
Program (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) 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
Table 3-21. Sample Values Inserted From a C/C++ Program and Their
Corresponding Expected Values in Nanosecond (page 2 of 2)
Value Specified in the
Fraction of the Client
Program Column Type
Expected Value in Column
of the SQL/MX Table