ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-21
SQL Interval Insertion Property
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
SQL Interval Insertion Property
The SQL Interval Insertion property includes zeroes at the beginning or end of an
interval datatype for micro or nano seconds. The SQL Interval Insertion has two
values:

SYSTEM_DEFAULT - Trailing zeroes are added to the fraction. For example,
0.1234 changes to 0.123400.

MSDN_DEFAULT - Leading zeroes are added to the fraction. For example, 0.1234
changes to 0.001234.
If not specified, the default is SYSTEM_DEFAULT.
Note. The 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