MX Release 3.2.1 (H06.26+, J06.15+)

Table 25 Sample Values Retrieved Using a C/C++ Program and Their Corresponding Expected

Values in Nanosecond (continued)

Value in the Fraction of the Client

ProgramColumn Type

Value in the Column of the SQL/MX

Table

87000000timestamp(3) or time(3)0.087

8000000timestamp(3) or time(3)0.008

0timestamp(3) or time(3)0.000

980000000timestamp(2) or time(2)0.98

90000000timestamp(2) or time(2)0.09

0timestamp(2) or time(2)0.00

900000000timestamp(1) or time(1)0.9

0timestamp(1) or time(1)0.0

NOTE: The OSS ODBC/MX 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 26 Fraction field values with SQL Fraction Precision Value: set to 6 or 9.

123456

Table

Precision/

Fraction

112123123412345123456123456

11212312341234501234512345

1121231234012340012341234

112123012300123000123123

11201200120001200001212

1010010001000010000011

SQL Interval Behaviour property

The SQL Interval Behaviour property includes zeroes at the beginning or end of an interval

datatype for micro or nano seconds. The SQL Interval Behaviour 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.

46 ODBC/MX Conformance