TIMESTAMP (Timestamp)

For historic reasons, this data type was also capable of representing a TIMESTAMP WITH TIME ZONE data type in JDBC, by making complicated use of java.util.Calendar when binding the type to a java.sql.PreparedStatement, or reading it from a java.sql.ResultSet. jOOQ, however, treats it as a java.time.LocalDateTime as suggested by various methods on the type, such as Timestamp.valueOf(LocalDateTime) or, more importantly, Timestamp.valueOf(String), which is not capable of parsing time zone information.

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

CREATE TABLE t (
  c datetime
)

CREATE TABLE t (
  c datetime NULL
)

CREATE TABLE t (
  c timestamp
)

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

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

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

CREATE TABLE t (
  c timestamp_ntz
)

CREATE TABLE t (
  c datetime2
)

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

cast(field("c"), TIMESTAMP)

cdate(c)

CAST(c AS datetime)

CAST(c AS timestamp)

CAST(c AS Nullable(timestamp))

CAST(c AS timestamp_ntz)

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

CAST(c AS datetime2)

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