Hp Integrity NonStop H-Series Manual de usuario descargar pdf (Pagina 46)

Table 14 Sample values retrieved by the application (continued)

Fraction value retrieved by the

applicationColumn type

Value in the column of the SQL/MX

Table

987000000timestamp(3) or time(3)0.987

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 applications can insert the time and timestamp values into the time and timestamp

columns of 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 15 includes a sample set of FRACTION_STRUCT field values when SQL Fraction

Precision Value: is set to 6 or 9.

Table 15 FRACTION_STRUCT 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.

46 Compatibility and considerations

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 61 62

Comentarios a estos manuales

Sin comentarios

Hp Integrity NonStop H-Series Manual de usuario Pagina 46

Comentarios a estos manuales

Relacionado con productos y manuales para Hardware De La Computadora Hp Integrity NonStop H-Series