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

Table 11 Sample values inserted from an application and expected values in microsecond (continued)

Expected value in the column of

SQL/MX tableColumn typeFraction value in the application

0.000timestamp(3) or time(3)54

0.000timestamp(3) or time(3)4

0.98timestamp(2) or time(2)987654

0.08timestamp(2) or time(2)87654

0.00timestamp(2) or time(2)7654

0.00timestamp(2) or time(2)654

0.00timestamp(2) or time(2)54

0.00timestamp(2) or time(2)4

0.9timestamp(1) or time(1)987654

0.0timestamp(1) or time(1)87654

0.0timestamp(1) or time(1)7654

0.0timestamp(1) or time(1)654

0.0timestamp(1) or time(1)54

0.0timestamp(1) or time(1)4

Table 12 includes a set of sample values and expected values in the column of an SQL/MX table

in nanoseconds.

Table 12 Sample values inserted from an application and expected values in nanoseconds

Expected value in the column of

SQL/MX table

Column typeFraction value in the application

0.987654timestamp(6) or time(6)987654321

0.087654timestamp(6) or time(6)87654321

0.007654timestamp(6) or time(6)7654321

0.000654timestamp(6) or time(6)654321

0.000054timestamp(6) or time(6)54321

0.000004timestamp(6) or time(6)4321

0.98765timestamp(5) or time(5)987654321

0.08765timestamp(5) or time(5)87654321

0.00765timestamp(5) or time(5)7654321

0.00065timestamp(5) or time(5)654321

0.00005timestamp(5) or time(5)54321

0.00000timestamp(5) or time(5)4321

0.9876timestamp(4) or time(4)987654321

0.0876timestamp(4) or time(4)87654321

0.0076timestamp(4) or time(4)7654321

0.0006timestamp(4) or time(4)654321

0.0000timestamp(4) or time(4)54321

Timestamp values with fraction 43

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 61 62

Sin comentarios

Hp Integrity NonStop H-Series Manual de usuario Pagina 43