TIMESTAMP WITH TIME ZONE (OffsetDateTime)

JDBC's standardisation of this type to java.time.OffsetDateTime is controversial as it is arguably the least useful representation of a "timestamp with time zone", compared to java.time.Instant (supported by jOOQ via INSTANT (Instant)) or java.time.ZonedDateTime (not currently supported by jOOQ, out of the box.) Users can override jOOQ's default by applying a Forced type configuration to their code generation setup, if they wish to change the default behaviour.

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

CREATE TABLE t (
  c timestamp with time zone
)

CREATE TABLE t (
  c timestamp with time zone NULL
)

CREATE TABLE t (
  c timestamp
)

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

CREATE TABLE t (
  c timestamptz
)

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

CREATE TABLE t (
  c timestamp_tz
)

CREATE TABLE t (
  c datetimeoffset
)

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website

cast(field("c"), TIMESTAMPWITHTIMEZONE)

cstr(c)

CAST(c AS timestamp with time zone)

CAST(c AS timestamp)

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

CAST(c AS timestamptz)

CAST(c AS timestamp_tz)

CAST(c AS datetimeoffset)

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website