MX 3.x)

ODBC/MX Conformance

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

3-16

Timestamp Values with Fraction

If a value of the SQLFractionValue property is set to 9 in the ODBCDSN file 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 3-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.

Table 3-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

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