MX 3.x)

ODBC/MX Conformance

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

5-18

Timestamp Values with Fraction

If a value of the SQL fraction precision property is set to SYSTEM_DEFAULT using the

SQL Fraction Precision Value: drop-down list and when a timestamp struct value is

retrieved using a C/C++ program from a column with type time or timestamp, the

fraction field selects the SYSTEM_DEFAULT values, which are listed in Table 5-22.

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

654321 timestamp(2) or time(2) 0.00

54321 timestamp(2) or time(2) 0.00

4321 timestamp(2) or time(2) 0.00

987654321 timestamp(1) or time(1) 0.9

87654321 timestamp(1) or time(1) 0.0

7654321 timestamp(1) or time(1) 0.0

654321 timestamp(1) or time(1) 0.0

54321 timestamp(1) or time(1) 0.0

4321 timestamp(1) or time(1) 0.0

Note. The default value of the SQL fraction precision property is SYSTEM_DEFAULT.

Table 5-21. Sample Values Inserted From a C/C++ Program and Their

Corresponding Expected Values in Nanosecond (page 2 of 2)

Value Specified in the

Fraction of the Client

Program Column Type

Expected Value in

Column of the SQL/MX

Table