Uses of Enum Class
org.jooq.DatePart

Packages that use DatePart

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of DatePart in org.jooq

Methods in org.jooq that return DatePart

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

Methods in org.jooq with parameters of type DatePart

Modifier and Type	Method	Description
@NotNull Field<Integer>	Field.extract(DatePart datePart)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.

Uses of DatePart in org.jooq.impl

Methods in org.jooq.impl that return DatePart

Modifier and Type	Method	Description
default @Nullable DatePart	QOM.DateAdd.$datePart()	The date part describing the interval
@NotNull DatePart	QOM.Extract.$datePart()

Methods in org.jooq.impl with parameters of type DatePart

Modifier and Type	Method	Description
default @NotNull QOM.DateAdd<T>	QOM.DateAdd.$datePart(DatePart newDatePart)	The date part describing the interval
static @NotNull Field<Date>	DSL.dateAdd(Date date, Number interval, DatePart datePart)	The DATE_ADD function.
static @NotNull Field<Date>	DSL.dateAdd(Date date, Field<? extends Number> interval, DatePart datePart)	The DATE_ADD function.
static @NotNull Field<Date>	DSL.dateAdd(Field<Date> date, Number interval, DatePart datePart)	The DATE_ADD function.
static @NotNull Field<Date>	DSL.dateAdd(Field<Date> date, Field<? extends Number> interval, DatePart datePart)	The DATE_ADD function.
static @NotNull Field<Integer>	DSL.dateDiff(DatePart part, Date startDate, Date endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.dateDiff(DatePart part, Date startDate, Field<Date> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.dateDiff(DatePart part, Field<Date> startDate, Date endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.dateDiff(DatePart part, Field<Date> startDate, Field<Date> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Date>	DSL.dateSub(Date date, Number interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<Date>	DSL.dateSub(Date date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<Date>	DSL.dateSub(Field<Date> date, Number interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<Date>	DSL.dateSub(Field<Date> date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<Integer>	DSL.extract(Temporal value, DatePart datePart)	Get the extract(field, datePart) function.
static <T extends Number> @NotNull Field<T>	DSL.extract(Temporal value, DatePart datePart, DataType<T> type)	Get the extract(field, datePart) function.
static @NotNull Field<Integer>	DSL.extract(Date value, DatePart datePart)	Get the extract(field, datePart) function.
static <T extends Number> @NotNull Field<T>	DSL.extract(Date value, DatePart datePart, DataType<T> type)	Get the extract(field, datePart) function.
static @NotNull Field<Integer>	DSL.extract(Field<?> field, DatePart datePart)	Get the extract(field, datePart) function.
static <T extends Number> @NotNull Field<T>	DSL.extract(Field<?> field, DatePart datePart, DataType<T> type)	Get the extract(field, datePart) function.
static @NotNull Field<Long>	DSL.extractLarge(Temporal value, DatePart datePart)	Get the extract(field, datePart) function.
static @NotNull Field<Long>	DSL.extractLarge(Date value, DatePart datePart)	Get the extract(field, datePart) function.
static @NotNull Field<Long>	DSL.extractLarge(Field<?> field, DatePart datePart)	Get the extract(field, datePart) function.
static @NotNull Field<LocalDate>	DSL.localDateAdd(LocalDate date, Number interval, DatePart datePart)	The LOCAL_DATE_ADD function.
static @NotNull Field<LocalDate>	DSL.localDateAdd(LocalDate date, Field<? extends Number> interval, DatePart datePart)	The LOCAL_DATE_ADD function.
static @NotNull Field<LocalDate>	DSL.localDateAdd(Field<LocalDate> date, Number interval, DatePart datePart)	The LOCAL_DATE_ADD function.
static @NotNull Field<LocalDate>	DSL.localDateAdd(Field<LocalDate> date, Field<? extends Number> interval, DatePart datePart)	The LOCAL_DATE_ADD function.
static @NotNull Field<Integer>	DSL.localDateDiff(DatePart part, LocalDate startDate, LocalDate endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateDiff(DatePart part, LocalDate startDate, Field<LocalDate> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateDiff(DatePart part, Field<LocalDate> startDate, LocalDate endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateDiff(DatePart part, Field<LocalDate> startDate, Field<LocalDate> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<LocalDate>	DSL.localDateSub(LocalDate date, Number interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<LocalDate>	DSL.localDateSub(LocalDate date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<LocalDate>	DSL.localDateSub(Field<LocalDate> date, Number interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<LocalDate>	DSL.localDateSub(Field<LocalDate> date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a date, given a date part.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeAdd(LocalDateTime date, Number interval, DatePart datePart)	The LOCAL_DATE_TIME_ADD function.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeAdd(LocalDateTime date, Field<? extends Number> interval, DatePart datePart)	The LOCAL_DATE_TIME_ADD function.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeAdd(Field<LocalDateTime> date, Number interval, DatePart datePart)	The LOCAL_DATE_TIME_ADD function.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeAdd(Field<LocalDateTime> date, Field<? extends Number> interval, DatePart datePart)	The LOCAL_DATE_TIME_ADD function.
static @NotNull Field<Integer>	DSL.localDateTimeDiff(DatePart part, LocalDateTime startDate, LocalDateTime endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateTimeDiff(DatePart part, LocalDateTime startDate, Field<LocalDateTime> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateTimeDiff(DatePart part, Field<LocalDateTime> startDate, LocalDateTime endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.localDateTimeDiff(DatePart part, Field<LocalDateTime> startDate, Field<LocalDateTime> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeSub(LocalDateTime date, Number interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeSub(LocalDateTime date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeSub(Field<LocalDateTime> date, Number interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<LocalDateTime>	DSL.localDateTimeSub(Field<LocalDateTime> date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<Timestamp>	DSL.timestampAdd(Timestamp date, Number interval, DatePart datePart)	The TIMESTAMP_ADD function.
static @NotNull Field<Timestamp>	DSL.timestampAdd(Timestamp date, Field<? extends Number> interval, DatePart datePart)	The TIMESTAMP_ADD function.
static @NotNull Field<Timestamp>	DSL.timestampAdd(Field<Timestamp> date, Number interval, DatePart datePart)	The TIMESTAMP_ADD function.
static @NotNull Field<Timestamp>	DSL.timestampAdd(Field<Timestamp> date, Field<? extends Number> interval, DatePart datePart)	The TIMESTAMP_ADD function.
static @NotNull Field<Integer>	DSL.timestampDiff(DatePart part, Timestamp startDate, Timestamp endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.timestampDiff(DatePart part, Timestamp startDate, Field<Timestamp> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.timestampDiff(DatePart part, Field<Timestamp> startDate, Timestamp endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Integer>	DSL.timestampDiff(DatePart part, Field<Timestamp> startDate, Field<Timestamp> endDate)	Get the date difference between endDate - startDate in terms of part.
static @NotNull Field<Timestamp>	DSL.timestampSub(Timestamp date, Number interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<Timestamp>	DSL.timestampSub(Timestamp date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<Timestamp>	DSL.timestampSub(Field<Timestamp> date, Number interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<Timestamp>	DSL.timestampSub(Field<Timestamp> date, Field<? extends Number> interval, DatePart datePart)	Subtract an interval from a timestamp, given a date part.
static @NotNull Field<Date>	DSL.trunc(Date date, DatePart part)	Truncate a date to a given datepart.
static @NotNull Field<Timestamp>	DSL.trunc(Timestamp timestamp, DatePart part)	Truncate a timestamp to a given datepart.
static @NotNull Field<LocalDate>	DSL.trunc(LocalDate date, DatePart part)	Truncate a date to a given datepart.
static @NotNull Field<LocalDateTime>	DSL.trunc(LocalDateTime timestamp, DatePart part)	Truncate a timestamp to a given datepart.
static <T> @NotNull Field<T>	DSL.trunc(Field<T> date, DatePart part)	Truncate a date or a timestamp to a given datepart.