The jOOQ User Manual SQL building Data types Built-in data types INTERVAL DAY TO SECOND (DayToSecond)

previous : next

INTERVAL DAY TO SECOND (DayToSecond)

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

The INTERVALDAYTOSECOND data type represents a DAY TO SECOND interval, or org.jooq.types.DayToSecond in Java. It has no representation in JDBC.

DDL support

Dialect support

This example using jOOQ:

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

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

CREATE TABLE t (
  c interval day to second
)

ASE, Sybase

CREATE TABLE t (
  c interval day to second NULL
)

ClickHouse

CREATE TABLE t (
  c Nullable(interval day to second)
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c interval day to second
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), INTERVALDAYTOSECOND)

Translates to the following dialect specific expressions:

Access

cdec(c)

ASE, Aurora MySQL, Aurora Postgres, BigQuery, CockroachDB, DB2, Databricks, Derby, Firebird, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS interval day to second)

ClickHouse

CAST(c AS Nullable(interval day to second))

DuckDB, Exasol, H2, HSQLDB, Oracle

CAST(c AS interval day(9) to second)

The jOOQ User Manual SQL building Data types Built-in data types INTERVAL DAY TO SECOND (DayToSecond)

previous : next