Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1 (H06.23+, J06.12+)
ODBC/MX Conformance
HP NonStop Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1—663857-001
3-15
Timestamp Values with Fraction
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
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 3-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










