Module org.jooq

Package org.jooq

Interface Period<T>

All Superinterfaces:

Named, QueryPart, Serializable, Typed<T>

@Pro
public interface Period<T>
extends Named, Typed<T>

A period specification for usage in temporal tables.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull PeriodSpecification	all()	Create a period specification for all timestamps.
@NotNull PeriodSpecification	asOf(Field<T> field)	Create a period specification for a given timestamp.
@NotNull PeriodSpecification	asOf(T value)	Create a period specification for a given timestamp.
@NotNull PeriodSpecificationBetweenAndStep<T>	between(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	between(Field<T> start, Field<T> end)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecificationBetweenAndStep<T>	between(T start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	between(T start, T end)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
@NotNull PeriodSpecification	containedIn(Field<T> start, Field<T> end)	Create a period specification for a given timestamp range containing this period.
@NotNull PeriodSpecification	containedIn(T start, T end)	Create a period specification for a given timestamp range containing this period.
@NotNull PeriodSpecificationFromToStep<T>	from(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
@NotNull PeriodSpecificationFromToStep<T>	from(T start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
@Nullable Field<T>	getEnd()	The expression specifying the end of the period.
@Nullable Field<T>	getStart()	The expression specifying the start of the period.

Methods inherited from interface org.jooq.Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Methods inherited from interface org.jooq.Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

getStart

@Nullable
@Nullable Field<T> getStart()

The expression specifying the start of the period.

getEnd

@Nullable
@Nullable Field<T> getEnd()

The expression specifying the end of the period.

asOf

@NotNull
@Support({COCKROACHDB,DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification asOf(T value)

Create a period specification for a given timestamp.

asOf

@NotNull
@Support({COCKROACHDB,DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification asOf(Field<T> field)

Create a period specification for a given timestamp.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecificationBetweenAndStep<T> between(T start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecificationBetweenAndStep<T> between(Field<T> start)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification between(T start,
 T end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

between

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification between(Field<T> start,
 Field<T> end)

Create a period specification for a given timestamp range overlapping with this period, including the end value.

from

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,SQLSERVER2016})
@NotNull PeriodSpecificationFromToStep<T> from(T start)

Create a period specification for a given timestamp range overlapping with this period, excluding the end value.

from

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,SQLSERVER2016})
@NotNull PeriodSpecificationFromToStep<T> from(Field<T> start)

Create a period specification for a given timestamp range overlapping with this period, excluding the end value.

containedIn

@NotNull
@Support(SQLSERVER2016)
@NotNull PeriodSpecification containedIn(T start,
 T end)

Create a period specification for a given timestamp range containing this period.

containedIn

@NotNull
@Support(SQLSERVER2016)
@NotNull PeriodSpecification containedIn(Field<T> start,
 Field<T> end)

Create a period specification for a given timestamp range containing this period.

all

@NotNull
@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
@NotNull PeriodSpecification all()

Create a period specification for all timestamps.