User Documentation
Ispirer Toolkit Overview
Pricing
HP Neoview Data Types - FLOAT
Versions: HP Neoview 2.4, 2.3 and 2.2
| HP Neoview - FLOAT | |
|---|---|
| Syntax | FLOAT[(p)] |
| Data | Floating-point numeric data |
| Parameters | p specifies the precision in binary digits |
| Range | +/-2.225e-308 to +/-1.797e+308, 1 ⇐ p ⇐ 54 |
| Default | p is 54 |
| Storage Size | 8 bytes |
| Standards | ANSI SQL |
HP Neoview FLOAT - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | FLOAT(p) |
| SQL Server | FLOAT(p) |
| MySQL | FLOAT(p,s) |
| PostgreSQL | FLOAT(p) |
| Sybase ASE | FLOAT(p) |
| Informix | FLOAT(p), p is ignored |
| Ingres | FLOAT |
| Data Types | |||
|---|---|---|---|
| Integers | LARGEINT | INT | SMALLINT |
| Fixed-point | DECIMAL(p,s) | NUMERIC(p,s) | |
| Floating-point | REAL | DOUBLE PRECISION | |
All Data Types