MX 3.x)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—640329-001

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