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-16
Timestamp Values with Fraction
Table 5-20. Sample Values Inserted From a C/C++ Program and Their
Corresponding Expected Values in Microsecond (page 1 of 2)
Value Specified in the
Fraction of the Client
Program Column Type
Expected Value in the
Column of the SQL/MX
Table
987654 timestamp(6) or time(6) 0.987654
87654 timestamp(6) or time(6) 0.087654
7654 timestamp(6) or time(6) 0.007654
654 timestamp(6) or time(6) 0.000654
54 timestamp(6) or time(6) 0.000054
4 timestamp(6) or time(6) 0.000004
987654 timestamp(5) or time(5) 0.98765
87654 timestamp(5) or time(5) 0.08765
7654 timestamp(5) or time(5) 0.00765
654 timestamp(5) or time(5) 0.00065
54 timestamp(5) or time(5) 0.00005
4 timestamp(5) or time(5) 0.00000
987654 timestamp(4) or time(4) 0.9876
87654 timestamp(4) or time(4) 0.0876
7654 timestamp(4) or time(4) 0.0076
654 timestamp(4) or time(4) 0.0006
54 timestamp(4) or time(4) 0.0000
4 timestamp(4) or time(4) 0.0000
987654 timestamp(3) or time(3) 0.987
87654 timestamp(3) or time(3) 0.087
7654 timestamp(3) or time(3) 0.007
654 timestamp(3) or time(3) 0.000
54 timestamp(3) or time(3) 0.000
4 timestamp(3) or time(3) 0.000
987654 timestamp(2) or time(2) 0.98
87654 timestamp(2) or time(2) 0.08
7654 timestamp(2) or time(2) 0.00
654 timestamp(2) or time(2) 0.00
54 timestamp(2) or time(2) 0.00
4 timestamp(2) or time(2) 0.00
987654 timestamp(1) or time(1) 0.9