The jOOQ User Manual SQL building Data types Built-in data types FLOAT (Double)

previous : next

FLOAT (Double)

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The FLOAT data type represents a variable bit floating point number, or java.lang.Double in Java, or Types.FLOAT in JDBC

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", FLOAT)

Translates to the following dialect specific expressions:

Access, Aurora MySQL, DB2, Derby, DuckDB, Exasol, H2, HSQLDB, Informix, MariaDB, MemSQL, MySQL, Oracle, SQLDataWarehouse, SQLServer, Snowflake, Teradata, Trino, Vertica

CREATE TABLE t (
  c float
)

ASE, Sybase

CREATE TABLE t (
  c float NULL
)

Aurora Postgres, CockroachDB, Postgres, Redshift, YugabyteDB

CREATE TABLE t (
  c float8
)

BigQuery

CREATE TABLE t (
  c float64
)

ClickHouse

CREATE TABLE t (
  c Nullable(float)
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c double
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

Firebird

CREATE TABLE t (
  c double precision
)

Hana, SQLite

CREATE TABLE t (
  c double
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), FLOAT)

Translates to the following dialect specific expressions:

Access

cdbl(c)

ASE, DB2, Derby, DuckDB, Exasol, H2, HSQLDB, Informix, Oracle, SQLDataWarehouse, SQLServer, Snowflake, Sybase, Teradata, Trino, Vertica

CAST(c AS float)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS decimal)

Aurora Postgres, CockroachDB, Postgres, Redshift, YugabyteDB

CAST(c AS float8)

BigQuery

CAST(c AS float64)

ClickHouse

CAST(c AS Nullable(float))

Databricks, Hana, SQLite

CAST(c AS double)

Firebird

CAST(c AS double precision)

The jOOQ User Manual SQL building Data types Built-in data types FLOAT (Double)

previous : next