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-18
Timestamp Values with Fraction
If a value of the SQL fraction precision property is set to SYSTEM_DEFAULT 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 selects the SYSTEM_DEFAULT values, which are listed in Table 5-22.
54321 timestamp(4) or time(4) 0.0000
4321 timestamp(4) or time(4) 0.0000
987654321 timestamp(3) or time(3) 0.987
87654321 timestamp(3) or time(3) 0.087
7654321 timestamp(3) or time(3) 0.007
654321 timestamp(3) or time(3) 0.000
54321 timestamp(3) or time(3) 0.000
4321 timestamp(3) or time(3) 0.000
987654321 timestamp(2) or time(2) 0.98
87654321 timestamp(2) or time(2) 0.08
7654321 timestamp(2) or time(2) 0.00
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
Note. The default value of the SQL fraction precision property is SYSTEM_DEFAULT.
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
Table 5-21. Sample Values Inserted From a C/C++ Program and Their
Corresponding Expected Values in Nanosecond (page2of2)
Value Specified in the
Fraction of the Client
Program Column Type
Expected Value in
Column of the SQL/MX
Table