- All Superinterfaces:
Named
,QueryPart
,Serializable
,Typed<T>
A period specification for usage in temporal tables.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull PeriodSpecification
all()
Create a period specification for all timestamps.@NotNull PeriodSpecification
Create a period specification for a given timestamp.@NotNull PeriodSpecification
Create a period specification for a given timestamp.@NotNull PeriodSpecificationBetweenAndStep<T>
Create a period specification for a given timestamp range overlapping with this period, including the end value.@NotNull PeriodSpecification
Create a period specification for a given timestamp range overlapping with this period, including the end value.@NotNull PeriodSpecificationBetweenAndStep<T>
Create a period specification for a given timestamp range overlapping with this period, including the end value.@NotNull PeriodSpecification
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>
Create a period specification for a given timestamp range overlapping with this period, excluding the end value.@NotNull PeriodSpecificationFromToStep<T>
Create a period specification for a given timestamp range overlapping with this period, excluding the end value.getEnd()
The expression specifying the end of the period.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
The expression specifying the start of the period. -
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
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.
-