Ispirer Ispirer
[HP Neoview Data Types - FLOAT]
 
You are here: » Ispirer Migration Knowledge Base » HP Neoview Database - Migration Reference » HP Neoview - Data Types » HP Neoview Data Types - FLOAT


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Neoview Request SQLWays

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

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird Ingres


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Neoview Request SQLWays

sqlways/neoview/data-types/float.txt · Last modified: March 20, 2013, 03:58:30 AM (external edit)
 
Ispirer Ispirer © 1999-2013, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement