Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - FLOAT

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - FLOAT
Syntax FLOAT[(p)]
Data Floating-point numeric data
Parameters p is the binary precision
Range Machine dependent
Storage Size 4 bytes if p < 16, 8 bytes if p >= 16
Internals if p < 16, FLOAT is stored as REAL, if p >= 16, FLOAT is stored as DOUBLE PRECISION
Standards ANSI SQL

Sybase ASE FLOAT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(p)
SQL Server FLOAT(p)
MySQL FLOAT(p,s)
PostgreSQL FLOAT(p)
Informix FLOAT(p), p is ignored
HP Neoview FLOAT(p)
Ingres FLOAT

Related Data Types in Sybase ASE

Data Types
Integers BIGINT INT SMALLINT TINYINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point REAL DOUBLE PRECISION

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.