DatePart (jOOQ 3.11.12 API)

java.lang.Object
- java.lang.Enum<DatePart>
- - org.jooq.DatePart

All Implemented Interfaces:

Serializable, Comparable<DatePart>
```
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

Enum Constant Summary

Enum Constants
Enum Constant and Description
`CENTURY` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`DAY` The day.
`DAY_OF_WEEK` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`DAY_OF_YEAR` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`DECADE` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`EPOCH` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`HOUR` The hour.
`MICROSECOND` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`MILLENNIUM` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`MILLISECOND` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`MINUTE` The minute.
`MONTH` The month.
`NANOSECOND` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`QUARTER` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`SECOND` The second.
`TIMEZONE` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`TIMEZONE_HOUR` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`TIMEZONE_MINUTE` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`WEEK` Deprecated. - 3.11 - [#2132] Support for this type is still experimental
`YEAR` The year.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`Keyword`	`toKeyword()`
`String`	`toSQL()`
`static DatePart`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static DatePart[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - YEAR
```
@Support
public static final DatePart YEAR
```
    The year. Corresponds to ChronoField.YEAR semantics.
  - MONTH
```
@Support
public static final DatePart MONTH
```
    The month. Corresponds to ChronoField.MONTH_OF_YEAR semantics.
  - DAY
```
@Support
public static final DatePart DAY
```
    The day. Corresponds to ChronoField.DAY_OF_MONTH semantics.
  - HOUR
```
@Support
public static final DatePart HOUR
```
    The hour. Corresponds to ChronoField.HOUR_OF_DAY semantics.
  - MINUTE
```
@Support
public static final DatePart MINUTE
```
    The minute. Corresponds to ChronoField.MINUTE_OF_HOUR semantics.
  - SECOND
```
@Support
public static final DatePart SECOND
```
    The second. Corresponds to ChronoField.SECOND_OF_MINUTE semantics.
  - MILLISECOND
```
@Support(value=SQLSERVER)
 @Deprecated
public static final DatePart MILLISECOND
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The millisecond.
  - MICROSECOND
```
@Support(value=SQLSERVER)
 @Deprecated
public static final DatePart MICROSECOND
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The microsecond.
  - NANOSECOND
```
@Support(value=SQLSERVER)
 @Deprecated
public static final DatePart NANOSECOND
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The nanosecond.
  - MILLENNIUM
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart MILLENNIUM
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The millennium. The year 2000 is in the 2nd millennium, the year 2001 in the 3rd.
  - CENTURY
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart CENTURY
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The century. The year 2000 is in the 20th century, the year 2001 in the 21st.
  - DECADE
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart DECADE
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The decade. The year divided by 10.
  - EPOCH
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart EPOCH
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The epoch in seconds since 1970-01-01.
  - QUARTER
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart QUARTER
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The quarter. Jan-Mar = 1, Apr-Jun = 2, Jul-Sep = 3, Oct-Dec = 4.
  - WEEK
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart WEEK
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The week of the year.
  - DAY_OF_YEAR
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart DAY_OF_YEAR
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The day of the year. Corresponds to ChronoField.DAY_OF_YEAR.
  - DAY_OF_WEEK
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart DAY_OF_WEEK
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The ISO day of the week. 1 = Monday, 2 = Tuesday, ..., 7 = Sunday. Corresponds to ChronoField.DAY_OF_WEEK .
  - TIMEZONE
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart TIMEZONE
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The timezone offset in seconds. Corresponds to ChronoField.OFFSET_SECONDS.
  - TIMEZONE_HOUR
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart TIMEZONE_HOUR
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The time zone offset's hour part.
  - TIMEZONE_MINUTE
```
@Support(value={AURORA_POSTGRES,POSTGRES})
 @Deprecated
public static final DatePart TIMEZONE_MINUTE
```
    Deprecated. - 3.11 - [#2132] Support for this type is still experimental
    
    The time zone offset's minute part.
- Method Detail
  - values
```
public static DatePart[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (DatePart c : DatePart.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static DatePart valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (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 type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - toSQL
```
public final String toSQL()
```
  - toKeyword
```
public final Keyword toKeyword()
```

Enum DatePart

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

YEAR

MONTH

DAY

HOUR

MINUTE

SECOND

MILLISECOND

MICROSECOND

NANOSECOND

MILLENNIUM

CENTURY

DECADE

EPOCH

QUARTER

WEEK

DAY_OF_YEAR

DAY_OF_WEEK

TIMEZONE

TIMEZONE_HOUR

TIMEZONE_MINUTE

Method Detail

values

valueOf

toSQL

toKeyword