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-17
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 a timestamp struct value is inserted from a C/C++
program into a column with type time or timestamp, the fraction field in the timestamp
struct is considered in nanoseconds.
Table 5-21 lists the sample values that can be inserted from a C/C++ program into the
required column type and their corresponding expected values in nanosecond.
87654 timestamp(1) or time(1) 0.0
7654 timestamp(1) or time(1) 0.0
654 timestamp(1) or time(1) 0.0
54 timestamp(1) or time(1) 0.0
4 timestamp(1) or time(1) 0.0
Table 5-21. Sample Values Inserted From a C/C++ Program and Their
Corresponding Expected Values in Nanosecond (page 1 of 2)
Value Specified in the
Fraction of the Client
Program Column Type
Expected Value in
Column of the SQL/MX
Table
987654321 timestamp(6) or time(6) 0.987654
87654321 timestamp(6) or time(6) 0.087654
7654321 timestamp(6) or time(6) 0.007654
654321 timestamp(6) or time(6) 0.000654
54321 timestamp(6) or time(6) 0.000054
4321 timestamp(6) or time(6) 0.000004
987654321 timestamp(5) or time(5) 0.98765
87654321 timestamp(5) or time(5) 0.08765
7654321 timestamp(5) or time(5) 0.00765
654321 timestamp(5) or time(5) 0.00065
54321 timestamp(5) or time(5) 0.00005
4321 timestamp(5) or time(5) 0.00000
987654321 timestamp(4) or time(4) 0.9876
87654321 timestamp(4) or time(4) 0.0876
7654321 timestamp(4) or time(4) 0.0076
654321 timestamp(4) or time(4) 0.0006
Table 5-20. Sample Values Inserted From a C/C++ Program and Their
Corresponding Expected Values in Microsecond (page 2 of 2)
Value Specified in the
Fraction of the Client
Program Column Type
Expected Value in the
Column of the SQL/MX
Table