MX Release 3.2 (H06.25+, J06.14+)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—691126-003

5-21

Timestamp Values with Fraction

Table 5-24 lists the values that the fraction field selects for inserting into the time and

timestamp columns when the SQL Fraction Precision Value: is set to 6 or 9.

Table 5-24. Fraction field values with SQL Fraction Precision Value: set to 6 or 9

You can set the SQL Interval Value Insertion property for the INTERVAL data type

behavior to be the same as MSDN behavior. This property is part of Microsoft ODBC

Data Source Administrator-> Data Access tab. The following examples illustrates an

insert into a INTERVAL DAY TO SECOND datatype column:

If this property is set to the default, SYSTEM_DEFAULT,

inserting 02 11:21:12.123 bound to the default data type,

SQL_CHAR, is inserted as 02 11:21:12.123000.

If the SQL Interval Value Insertion property is set to

MSDN_DEFAULT, 02:11:21:12.000123 is inserted.

You can set the SQL Datetime Retrieval property for DATETIME (SQL/MP Tables)

data type behavior to be the same as MSDN behavior. This property is part of

Microsoft ODBC Data Source Administrator-> Data Access tab.

Note. TThe ODBC programs can insert the time and timestamp values into the time

and timestamp columns of an SQL/MX table using the FRACTION_STRUCT structure.

The structure fields are:

struct FRACTION_STRUCT {

SQLUINTEGER day,

SQLUINTEGER hour,SQLUINTEGER minute,

SQLUINTEGER second,

SQLUINTEGER fraction

};

Table

Precision/

Fraction 6 5 4 3 2 1

123456 123456 12345 1234 123 12 1

12345 012345 12345 1234 123 12 1

1234 001234 01234 1234 123 12 1

123 000123 00123 0123 123 12 1

12 000012 00012 0012 012 12 1

1 000001 00001 0001 001 01 1