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
PeriodSpecification	all()	Create a period specification for all timestamps.
PeriodSpecification	asOf(Field<T> field)	Create a period specification for a given timestamp.
PeriodSpecification	asOf(T value)	Create a period specification for a given timestamp.
PeriodSpecificationBetweenAndStep<T>	between(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
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.
PeriodSpecificationBetweenAndStep<T>	between(T start)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
PeriodSpecification	between(T start, T end)	Create a period specification for a given timestamp range overlapping with this period, including the end value.
PeriodSpecification	containedIn(Field<T> start, Field<T> end)	Create a period specification for a given timestamp range containing this period.
PeriodSpecification	containedIn(T start, T end)	Create a period specification for a given timestamp range containing this period.
PeriodSpecificationFromToStep<T>	from(Field<T> start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
PeriodSpecificationFromToStep<T>	from(T start)	Create a period specification for a given timestamp range overlapping with this period, excluding the end value.
Field<T>	getEnd()	The expression specifying the end of the period.
Field<T>	getStart()	The expression specifying the start of the period.

Methods inherited from interface org.jooq.Named

getComment, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Method Detail

getStart

Field<T> getStart()

The expression specifying the start of the period.

getEnd

Field<T> getEnd()

The expression specifying the end of the period.

asOf

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

Create a period specification for a given timestamp.

asOf

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

Create a period specification for a given timestamp.

between

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

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

between

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

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

between

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

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

between

@Support({DB2,HSQLDB,MARIADB_10_3,ORACLE12C,SQLSERVER2016})
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

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

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

from

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

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

containedIn

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

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

containedIn

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

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

all

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

Create a period specification for all timestamps.