Module org.jooq

Package org.jooq

Enum Class DatePart

java.lang.Object

java.lang.Enum<DatePart>

org.jooq.DatePart

All Implemented Interfaces:

Serializable, Comparable<DatePart>, Constable

public enum DatePart
extends Enum<DatePart>

A date part can be used with SQL functions such as extract(). It describes a part of a date / datetime value

Author:

Lukas Eder

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
CENTURY	The century.
DAY	The day.
DAY_OF_WEEK	The day of the week.
DAY_OF_YEAR	The day of the year.
DECADE	The decade.
EPOCH	The epoch in seconds since 1970-01-01.
HOUR	The hour.
ISO_DAY_OF_WEEK	The ISO day of the week.
MICROSECOND	The microsecond.
MILLENNIUM	The millennium.
MILLISECOND	The millisecond.
MINUTE	The minute.
MONTH	The month.
NANOSECOND	The nanosecond.
QUARTER	The quarter.
SECOND	The second.
TIMEZONE	The timezone offset in seconds.
TIMEZONE_HOUR	The time zone offset's hour part.
TIMEZONE_MINUTE	The time zone offset's minute part.
WEEK	The week of the year.
YEAR	The year.

Method Summary

Modifier and Type	Method	Description
final Keyword	toKeyword()
final Name	toName()
final String	toSQL()
static DatePart	valueOf(String name)	Returns the enum constant of this class with the specified name.
static DatePart[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

YEAR

@NotNull
@Support
public static final DatePart YEAR

The year. Corresponds to ChronoField.YEAR semantics.

MONTH

@NotNull
@Support
public static final DatePart MONTH

The month. Corresponds to ChronoField.MONTH_OF_YEAR semantics.

DAY

@NotNull
@Support
public static final DatePart DAY

The day. Corresponds to ChronoField.DAY_OF_MONTH semantics.

HOUR

@NotNull
@Support
public static final DatePart HOUR

The hour. Corresponds to ChronoField.HOUR_OF_DAY semantics.

MINUTE

@NotNull
@Support
public static final DatePart MINUTE

The minute. Corresponds to ChronoField.MINUTE_OF_HOUR semantics.

SECOND

@NotNull
@Support
public static final DatePart SECOND

The second. Corresponds to ChronoField.SECOND_OF_MINUTE semantics.

MILLISECOND

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,HSQLDB,POSTGRES,SQLSERVER})
public static final DatePart MILLISECOND

The millisecond.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

MICROSECOND

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,POSTGRES,SQLSERVER})
public static final DatePart MICROSECOND

The microsecond.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

NANOSECOND

@NotNull
@Support({H2,HSQLDB,SQLSERVER})
public static final DatePart NANOSECOND

The nanosecond.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

MILLENNIUM

@NotNull
@Support
public static final DatePart MILLENNIUM

The millennium. The year 2000 is in the 2nd millennium, the year 2001 in the 3rd.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

CENTURY

@NotNull
@Support
public static final DatePart CENTURY

The century. The year 2000 is in the 20th century, the year 2001 in the 21st.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

DECADE

@NotNull
@Support
public static final DatePart DECADE

The decade. The year divided by 10.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

EPOCH

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE})
public static final DatePart EPOCH

The epoch in seconds since 1970-01-01.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

QUARTER

@NotNull
@Support
public static final DatePart QUARTER

The quarter. Jan-Mar = 1, Apr-Jun = 2, Jul-Sep = 3, Oct-Dec = 4.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

WEEK

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES})
public static final DatePart WEEK

The week of the year.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

DAY_OF_YEAR

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE})
public static final DatePart DAY_OF_YEAR

The day of the year. Corresponds to ChronoField.DAY_OF_YEAR.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

DAY_OF_WEEK

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE})
public static final DatePart DAY_OF_WEEK

The day of the week. 1 = Sunday, 2 = Monday, ..., 7 = Saturday. Corresponds to ChronoField.DAY_OF_WEEK, shifted by one day.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

ISO_DAY_OF_WEEK

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE})
public static final DatePart ISO_DAY_OF_WEEK

The ISO day of the week. 1 = Monday, 2 = Tuesday, ..., 7 = Sunday. Corresponds to ChronoField.DAY_OF_WEEK.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

TIMEZONE

@NotNull
@Support({AURORA_POSTGRES,H2,HSQLDB,POSTGRES})
public static final DatePart TIMEZONE

The timezone offset in seconds. Corresponds to ChronoField.OFFSET_SECONDS.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

TIMEZONE_HOUR

@NotNull
@Support({AURORA_POSTGRES,H2,HSQLDB,POSTGRES})
public static final DatePart TIMEZONE_HOUR

The time zone offset's hour part.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

TIMEZONE_MINUTE

@NotNull
@Support({AURORA_POSTGRES,H2,HSQLDB,POSTGRES})
public static final DatePart TIMEZONE_MINUTE

The time zone offset's minute part.

The documented Support is for DSL.extract(Field, DatePart), and possibly other temporal functions. It does not guarantee support on all temporal functions.

Method Details

values

public static DatePart[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static DatePart valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

toSQL

public final String toSQL()

toKeyword

public final Keyword toKeyword()

toName

public final Name toName()