Hp Integrity NonStop H-Series User Manual download pdf (Page 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

No comments

Hp Integrity NonStop H-Series User Manual Page 43