The jOOQ User Manual SQL building Data types Built-in data types LOCALDATETIME (LocalDateTime)

previous : next

LOCALDATETIME (LocalDateTime)

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

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

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access, Aurora MySQL, BigQuery, MemSQL, MySQL, SQLDataWarehouse, SQLite

CREATE TABLE t (
  c datetime
)

ASE, MariaDB, Sybase

CREATE TABLE t (
  c datetime NULL
)

Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Oracle, Postgres, Redshift, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c timestamp
)

ClickHouse

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

Databricks

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

Informix

CREATE TABLE t (
  c datetime year to fraction(5)
)

Snowflake

CREATE TABLE t (
  c timestamp_ntz
)

SQLServer

CREATE TABLE t (
  c datetime2
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), LOCALDATETIME)

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE, Aurora MySQL, BigQuery, MariaDB, MemSQL, MySQL, SQLDataWarehouse, SQLite, Sybase

CAST(c AS datetime)

Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Oracle, Postgres, Redshift, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS timestamp)

ClickHouse

CAST(c AS Nullable(Nullable(timestamp)))

Databricks, Snowflake

CAST(c AS timestamp_ntz)

Informix

CAST(CAST(c AS datetime year to fraction(5)) AS datetime year to fraction(5))

SQLServer

CAST(c AS datetime2)

The jOOQ User Manual SQL building Data types Built-in data types LOCALDATETIME (LocalDateTime)

previous : next