The jOOQ User Manual SQL building Data types Built-in data types LOCALDATE (LocalDate)

previous : next

LOCALDATE (LocalDate)

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

The LOCALDATE is a java.time bound variant of the DATE type, when the old JDBC binding should be avoided, i.e. java.time.LocalDate in Java, or Types.DATE in JDBC.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access

CREATE TABLE t (
  c datetime
)

ASE, Sybase

CREATE TABLE t (
  c date NULL
)

Aurora MySQL, Aurora Postgres, BigQuery, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Oracle, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c date
)

ClickHouse

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

Databricks

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

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), LOCALDATE)

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE, Aurora MySQL, Aurora Postgres, BigQuery, CockroachDB, DB2, Databricks, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Oracle, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS date)

ClickHouse

CAST(c AS Nullable(Nullable(date)))

The jOOQ User Manual SQL building Data types Built-in data types LOCALDATE (LocalDate)

previous : next