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

previous : next

DOUBLE (Double)

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

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

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access, Informix, Oracle, SQLDataWarehouse, SQLServer, Snowflake

CREATE TABLE t (
  c float
)

ASE

CREATE TABLE t (
  c double precision NULL
)

Aurora MySQL, DB2, Derby, DuckDB, Exasol, H2, HSQLDB, Hana, MariaDB, MemSQL, MySQL, SQLite, Trino

CREATE TABLE t (
  c double
)

Aurora Postgres, CockroachDB, Firebird, Postgres, Redshift, Teradata, Vertica, YugabyteDB

CREATE TABLE t (
  c double precision
)

BigQuery

CREATE TABLE t (
  c float64
)

ClickHouse

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

Databricks

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

Sybase

CREATE TABLE t (
  c double NULL
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), DOUBLE)

Translates to the following dialect specific expressions:

Access

cdbl(c)

ASE, Aurora Postgres, CockroachDB, Firebird, Postgres, Redshift, Teradata, Vertica, YugabyteDB

CAST(c AS double precision)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS decimal)

BigQuery

CAST(c AS float64)

ClickHouse

CAST(c AS Nullable(double))

DB2, Databricks, Derby, DuckDB, Exasol, H2, HSQLDB, Hana, SQLite, Sybase, Trino

CAST(c AS double)

Informix, Oracle, SQLDataWarehouse, SQLServer, Snowflake

CAST(c AS float)

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

previous : next