jOOQ 3.18.7 · org.jooq.impl.DateDiff

Field Summary

Modifier and Type	Field and Description
private final Field<T>	endDate Deprecated as a consequence of `Field` being deprecated.
private final DatePart	part
private final Field<T>	startDate Deprecated as a consequence of `Field` being deprecated.

Constructor Summary

Access	Constructor and Description
pack-priv	DateDiff(DatePart part, Field<T> startDate, Field<T> endDate) Deprecated as a consequence of `Field` being deprecated.

Method Summary

Modifier and Type	Method and Description
public final void	accept(Context<?> ctx) Implements abstract org.jooq.impl.AbstractField.accept. Implements org.jooq.QueryPartInternal.accept. This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables.
private final Field<Integer>	monthDiff(DatePart p) Deprecated as a consequence of `Field` being deprecated. Calculate the difference for `DatePart#MONTH` or month-based date parts like `DatePart#QUARTER`.
private final Field<Integer>	partDiff(DatePart p) Deprecated as a consequence of `Field` being deprecated.

Inherited from org.jooq.impl.AbstractField:: $alias $aliased abs acos add add as as as as asc ascii asin atan atan2 atan2 avg avgOver between between between between betweenSymmetric betweenSymmetric betweenSymmetric betweenSymmetric bitAnd bitAnd bitLength bitNand bitNand bitNor bitNor bitNot bitOr bitOr bitXNor bitXNor bitXor bitXor cast cast cast ceil changed charLength clauses coalesce coalesce coerce coerce coerce collate collate collate comment comment compare compare compare compare concat concat concat contains contains containsIgnoreCase containsIgnoreCase convert convert convert convertFrom convertFrom convertTo convertTo cos cosh cot coth count countDistinct countOver decode decode decode decode deg desc div div divide divide endsWith endsWith endsWithIgnoreCase endsWithIgnoreCase eq eq eq eq equal equal equal equal equalIgnoreCase equalIgnoreCase exp extract field firstValue floor from ge ge ge ge get getValue greaterOrEqual greaterOrEqual greaterOrEqual greaterOrEqual greaterThan greaterThan greaterThan greaterThan greatest greatest gt gt gt gt in in in in in isDistinctFrom isDistinctFrom isDistinctFrom isDocument isFalse isJson isNotDistinctFrom isNotDistinctFrom isNotDistinctFrom isNotDocument isNotJson isNotNull isNull isNullable isPossiblyNullable isTrue lag lag lag lag lastValue le le le le lead lead lead lead least least length lessOrEqual lessOrEqual lessOrEqual lessOrEqual lessThan lessThan lessThan lessThan like like like like like likeIgnoreCase likeIgnoreCase likeIgnoreCase likeIgnoreCase likeRegex likeRegex ln log lower lpad lpad lpad lpad lt lt lt lt ltrim max maxOver median min minOver minus minus mod mod modulo modulo mul mul multiply multiply ne ne ne ne neg notBetween notBetween notBetween notBetween notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notContains notContains notContainsIgnoreCase notContainsIgnoreCase notEqual notEqual notEqual notEqual notEqualIgnoreCase notEqualIgnoreCase notIn notIn notIn notIn notIn notLike notLike notLike notLike notLike notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeRegex notLikeRegex notSimilarTo notSimilarTo notSimilarTo notSimilarTo notSimilarTo nullif nullif nullsFirst nullsLast nvl nvl nvl2 nvl2 octetLength original parenthesised plus plus position position pow pow power power projectionSize rad rem rem repeat repeat replace replace replace replace reset round round rpad rpad rpad rpad rtrim shl shl shr shr sign similarTo similarTo similarTo similarTo similarTo sin sinh sort sort sortAsc sortAsc sortDefault sortDesc sortDesc sqrt startsWith startsWith startsWithIgnoreCase startsWithIgnoreCase stddevPop stddevPopOver stddevSamp stddevSampOver sub sub substring substring substring substring subtract subtract sum sumOver tan tanh times times trim unaryMinus unaryPlus upper varPop varPopOver varSamp varSampOver

Field Detail

endDate	back to summary
private final Field<T> endDate Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information.

part	back to summary
private final DatePart part

startDate	back to summary
private final Field<T> startDate Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information.

Constructor Detail

DateDiff	back to summary
pack-priv DateDiff(DatePart part, Field<T> startDate, Field<T> endDate) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information.

Method Detail

accept back to summary

accept	back to summary
public final void accept(Context<?> ctx) Implements abstract org.jooq.impl.AbstractField.accept. Implements org.jooq.QueryPartInternal.accept. Doc from org.jooq.QueryPartInternal.accept. This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables. Annotations @Override

public final void accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations

@Override

monthDiff	back to summary
private final Field<Integer> monthDiff(DatePart p) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Calculate the difference for `DatePart#MONTH` or month-based date parts like `DatePart#QUARTER`.

partDiff	back to summary
private final Field<Integer> partDiff(DatePart p) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information.

pack-priv final Class DateDiff<T>

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail