The jOOQ User Manual SQL building Data types Built-in data types TIME (Time)

previous : next

TIME (Time)

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

The TIME data type represents a local time type, or java.sql.Time in Java, or Types.TIME 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", TIME)

Translates to the following dialect specific expressions:

Access, Informix, SQLite

CREATE TABLE t (
  c datetime
)

ASE, Sybase

CREATE TABLE t (
  c time NULL
)

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

CREATE TABLE t (
  c time
)

ClickHouse

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

Databricks

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

Oracle

CREATE TABLE t (
  c timestamp
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), TIME)

Translates to the following dialect specific expressions:

Access

cdate(c)

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

CAST(c AS time)

ClickHouse

CAST(c AS Nullable(time))

Informix

CAST(c AS datetime hour to second)

Oracle

CAST(c AS timestamp)

SQLite

CAST(c AS datetime)

The jOOQ User Manual SQL building Data types Built-in data types TIME (Time)

previous : next