Hp Integrity NonStop H-Series Uživatelský manuál stáhnout pdf (Strana 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

Žádné komentáře

Hp Integrity NonStop H-Series Uživatelský manuál Strana 43