Interface TemporalExpression<T extends Temporal & Comparable<? super T>>

Type Parameters:

T - the temporal type of the expression

All Superinterfaces:

ComparableExpression<T>, Expression<T>, Selection<T>, TupleElement<T>

public interface TemporalExpression<T extends Temporal & Comparable<? super T>>
extends ComparableExpression<T>

Type for temporal query expressions.

Since:

4.0

Method Summary

Modifier and Type	Method	Description
default Predicate	after(Expression<? extends T> y)	Synonym for ComparableExpression.greaterThan(Expression).
default Predicate	after(T y)	Synonym for ComparableExpression.greaterThan(Comparable).
default Predicate	before(Expression<? extends T> y)	Synonym for ComparableExpression.lessThan(Expression).
default Predicate	before(T y)	Synonym for ComparableExpression.lessThan(Comparable).
TemporalExpression<T>	coalesce(Expression<? extends T> y)	Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.
TemporalExpression<T>	coalesce(T y)	Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.
<N extends Number & Comparable<N>> NumericExpression<N>	extract(TemporalField<N,T> field)	Create an expression that returns the value of a field extracted from this date.
TemporalExpression<T>	nullif(Expression<? extends T> y)	Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.
TemporalExpression<T>	nullif(T y)	Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Methods inherited from interface ComparableExpression

asc, asc, between, between, desc, desc, greaterThan, greaterThan, greaterThanOrEqualTo, greaterThanOrEqualTo, lessThan, lessThan, lessThanOrEqualTo, lessThanOrEqualTo, max, min

Methods inherited from interface Expression

as, cast, count, countDistinct, equalTo, equalTo, in, in, in, in, in, isMember, isNotMember, isNotNull, isNull, notEqualTo, notEqualTo, selectCase

Methods inherited from interface Selection

alias, getCompoundSelectionItems, isCompoundSelection

Methods inherited from interface TupleElement

getAlias, getJavaType

Method Details

extract

@Nonnull
<N extends Number & Comparable<N>>
NumericExpression<N> extract(@Nonnull
 TemporalField<N,T> field)

Create an expression that returns the value of a field extracted from this date.

Type Parameters:

N - the type of the extracted value

Parameters:

field - a temporal field type

Returns:

expression for the value of the extracted field

See Also:

• CriteriaBuilder.extract(TemporalField, Expression)

coalesce

@Nonnull
TemporalExpression<T> coalesce(T y)

Description copied from interface: Expression

Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.

Specified by:

coalesce in interface ComparableExpression<T extends Temporal & Comparable<? super T>>

Specified by:

coalesce in interface Expression<T extends Temporal & Comparable<? super T>>

Parameters:

y - value

Returns:

coalesce expression

coalesce

@Nonnull
TemporalExpression<T> coalesce(@Nonnull
 Expression<? extends T> y)

Description copied from interface: Expression

Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.

Specified by:

coalesce in interface ComparableExpression<T extends Temporal & Comparable<? super T>>

Specified by:

coalesce in interface Expression<T extends Temporal & Comparable<? super T>>

Parameters:

y - expression

Returns:

coalesce expression

nullif

@Nonnull
TemporalExpression<T> nullif(T y)

Description copied from interface: Expression

Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface ComparableExpression<T extends Temporal & Comparable<? super T>>

Specified by:

nullif in interface Expression<T extends Temporal & Comparable<? super T>>

Parameters:

y - value

Returns:

nullif expression

nullif

@Nonnull
TemporalExpression<T> nullif(@Nonnull
 Expression<? extends T> y)

Description copied from interface: Expression

Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface ComparableExpression<T extends Temporal & Comparable<? super T>>

Specified by:

nullif in interface Expression<T extends Temporal & Comparable<? super T>>

Parameters:

y - expression

Returns:

nullif expression

before

@Nonnull
default Predicate before(@Nonnull
 Expression<? extends T> y)

Synonym for ComparableExpression.lessThan(Expression).

Parameters:

y - expression

Returns:

before predicate

before

@Nonnull
default Predicate before(@Nonnull
 T y)

Synonym for ComparableExpression.lessThan(Comparable).

Parameters:

y - value

Returns:

before predicate

after

@Nonnull
default Predicate after(@Nonnull
 Expression<? extends T> y)

Synonym for ComparableExpression.greaterThan(Expression).

Parameters:

y - expression

Returns:

after predicate

after

@Nonnull
default Predicate after(@Nonnull
 T y)

Synonym for ComparableExpression.greaterThan(Comparable).

Parameters:

y - value

Returns:

after predicate