Hp Integrity NonStop H-Series Manual do Utilizador descarregar pdf (Página 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

Sem comentários

Hp Integrity NonStop H-Series Manual do Utilizador Página 43