Hp Integrity NonStop H-Series Bedienungsanleitung PDF herunterladen (Seite 44)

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

Expected value in the column of

SQL/MX table

Column typeFraction value in the application

0.0000timestamp(4) or time(4)4321

0.987timestamp(3) or time(3)987654321

0.087timestamp(3) or time(3)87654321

0.007timestamp(3) or time(3)7654321

0.000timestamp(3) or time(3)654321

0.000timestamp(3) or time(3)54321

0.000timestamp(3) or time(3)4321

0.98timestamp(2) or time(2)987654321

0.08timestamp(2) or time(2)87654321

0.00timestamp(2) or time(2)7654321

0.00timestamp(2) or time(2)654321

0.00timestamp(2) or time(2)54321

0.00timestamp(2) or time(2)4321

0.9timestamp(1) or time(1)987654321

0.0timestamp(1) or time(1)87654321

0.0timestamp(1) or time(1)7654321

0.0timestamp(1) or time(1)654321

0.0timestamp(1) or time(1)54321

0.0timestamp(1) or time(1)4321

Table 13 includes a set of sample values retrieved by the application when SQLFractionValue is

set to SYSTEM_DEFAULT or to a value other than 9.

Table 13 Values retrieved by the application for SYSTEM_DEFAULT setting

Fraction value retrieved by the

applicationColumn type

Value in the column of the SQL/MX

Table

987654timestamp(6) or time(6)0.987654

87654timestamp(6) or time(6)0.087654

7654timestamp(6) or time(6)0.007654

654timestamp(6) or time(6)0.000654

54timestamp(6) or time(6)0.000054

4timestamp(6) or time(6)0.000004

98765timestamp(5) or time(5)0.98765

8765timestamp(5) or time(5)0.08765

765timestamp(5) or time(5)0.00765

65timestamp(5) or time(5)0.00065

5timestamp(5) or time(5)0.00005

0timestamp(5) or time(5)0.00000

44 Compatibility and considerations

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

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Integrity NonStop H-Series Bedienungsanleitung Seite 44

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Computerhardware Hp Integrity NonStop H-Series