All versions: 3.11 | 3.10 | 3.9 | 3.8 | 3.7 | Development versions: 3.12 | Unsupported versions: 3.6 | 3.5 | 3.4 | 3.3 | 3.2 | 2.6

Date and time functions

This is a list of date and time functions supported by jOOQ's DSL:

  • CURRENT_DATE: Get current date as a DATE object.
  • CURRENT_TIME: Get current time as a TIME object.
  • CURRENT_TIMESTAMP: Get current date as a TIMESTAMP object.
  • DATE_ADD: Add a number of days or an interval to a date.
  • DATE_DIFF: Get the difference in days between two dates.
  • TIMESTAMP_ADD: Add a number of days or an interval to a timestamp.
  • TIMESTAMP_DIFF: Get the difference as an INTERVAL DAY TO SECOND between two dates.

Intervals in jOOQ

jOOQ fills a gap opened by JDBC, which neglects an important SQL data type as defined by the SQL standards: INTERVAL types. See the manual's section about INTERVAL data types for more details.

The jOOQ Logo