The jOOQ User Manual SQL building Data types Built-in data types TIME WITH TIME ZONE (OffsetTime)

previous : next

TIME WITH TIME ZONE (OffsetTime)

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

The TIME WITH TIME ZONE data type represents an offset date time type, or java.time.OffsetTime in Java, or Types.TIME_WITH_TIMEZONE in JDBC.

Some dialects support an explicit precision flag on this data type. If absent, the default is dialect specific.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

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

CREATE TABLE t (
  c time with time zone
)

ASE, Sybase

CREATE TABLE t (
  c time with time zone NULL
)

ClickHouse

CREATE TABLE t (
  c Nullable(time with time zone)
)
ENGINE Log()

Databricks

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

Oracle

CREATE TABLE t (
  c timestamp with time zone
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), TIMEWITHTIMEZONE)

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, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS time with time zone)

ClickHouse

CAST(c AS Nullable(time with time zone))

Oracle

CAST(c AS timestamp with time zone)

The jOOQ User Manual SQL building Data types Built-in data types TIME WITH TIME ZONE (OffsetTime)

previous : next