Uses of Enum Class
org.hibernate.query.common.TemporalUnit
Packages that use TemporalUnit
Package
Description
This package abstracts over the multifarious dialects of SQL
understood by the databases supported by Hibernate.
Common APIs used internally, in the SQL tree,
in the dialects, and in the criteria query API.
The JPA-standard criteria query API defines all the operations needed express
any query written in standard JPQL.
SPI for extending
HibernateCriteriaBuilder
with additional functionality by registering a Service
.Package for the SQM-backed Query implementation details
Nodes representing expressions in the SQM tree.
Package defining support for creating and consuming a SQL AST.
AST nodes representing expressions in a SQL tree.
-
Uses of TemporalUnit in org.hibernate.dialect
Methods in org.hibernate.dialect with parameters of type TemporalUnitModifier and TypeMethodDescriptionCockroachDialect.extractPattern
(TemporalUnit unit) Theextract()
function returnsDAY_OF_WEEK
numbered from 0 to 6.DB2Dialect.extractPattern
(TemporalUnit unit) Dialect.extractPattern
(TemporalUnit unit) Obtain a pattern for the SQL equivalent to anextract()
function call.DialectDelegateWrapper.extractPattern
(TemporalUnit unit) H2Dialect.extractPattern
(TemporalUnit unit) In H2, the extract() function does not return fractional seconds for the fieldSECOND
.HANADialect.extractPattern
(TemporalUnit unit) HANA has no extract() function, but we can emulate it using the appropriate named functions instead of extract().HSQLDialect.extractPattern
(TemporalUnit unit) MySQLDialect.extractPattern
(TemporalUnit unit) MySQL supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using the appropriate named functions instead of extract().OracleDialect.extractPattern
(TemporalUnit unit) Oracle supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using to_char() with a format string instead of extract().PostgreSQLDialect.extractPattern
(TemporalUnit unit) Theextract()
function returnsDAY_OF_WEEK
numbered from 0 to 6.SQLServerDialect.extractPattern
(TemporalUnit unit) SybaseDialect.extractPattern
(TemporalUnit unit) CockroachDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) DB2Dialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) DB2zDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) Dialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) Obtain a pattern for the SQL equivalent to atimestampadd()
function call.DialectDelegateWrapper.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) H2Dialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) HANADialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) HSQLDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) MySQLDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) OracleDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) PostgreSQLDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) SpannerDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) SQLServerDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) SybaseASEDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) SybaseDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) TiDBDialect.timestampaddPattern
(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType) CockroachDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) DB2Dialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) Dialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) Obtain a pattern for the SQL equivalent to atimestampdiff()
function call.DialectDelegateWrapper.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) H2Dialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) HANADialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) HSQLDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) MySQLDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) OracleDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) PostgresPlusDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) PostgreSQLDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) SpannerDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) SQLServerDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) SybaseASEDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) SybaseDialect.timestampdiffPattern
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) static String
DB2Dialect.timestampdiffPatternV10
(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType) CockroachDialect.translateDurationField
(TemporalUnit unit) Dialect.translateDurationField
(TemporalUnit unit) Return the name used to identify the given unit of duration as an argument to#timestampadd()
or#timestampdiff()
, or of this dialect's equivalent functions.DialectDelegateWrapper.translateDurationField
(TemporalUnit unit) SQLServerDialect.translateDurationField
(TemporalUnit unit) CockroachDialect.translateExtractField
(TemporalUnit unit) DB2Dialect.translateExtractField
(TemporalUnit unit) Dialect.translateExtractField
(TemporalUnit unit) Return the name used to identify the given field as an argument to theextract()
function, or of this dialect's equivalent function.DialectDelegateWrapper.translateExtractField
(TemporalUnit unit) H2Dialect.translateExtractField
(TemporalUnit unit) HSQLDialect.translateExtractField
(TemporalUnit unit) PostgreSQLDialect.translateExtractField
(TemporalUnit unit) SpannerDialect.translateExtractField
(TemporalUnit unit) SQLServerDialect.translateExtractField
(TemporalUnit unit) SybaseDialect.translateExtractField
(TemporalUnit unit) -
Uses of TemporalUnit in org.hibernate.query.common
Methods in org.hibernate.query.common that return TemporalUnitModifier and TypeMethodDescriptionTemporalUnit.normalized()
The unit that this unit "normalizes to", eitherNANOSECOND
orMONTH
, which represent the two basic types of duration: "physical" durations, and "calendar" durations.static TemporalUnit
Returns the enum constant of this class with the specified name.static TemporalUnit[]
TemporalUnit.values()
Returns an array containing the constants of this enum class, in the order they are declared.Methods in org.hibernate.query.common with parameters of type TemporalUnitModifier and TypeMethodDescriptionTemporalUnit.conversionFactor
(TemporalUnit unit, Dialect dialect) TemporalUnit.conversionFactorFull
(TemporalUnit unit, Dialect dialect) -
Uses of TemporalUnit in org.hibernate.query.criteria
Methods in org.hibernate.query.criteria with parameters of type TemporalUnitModifier and TypeMethodDescriptionHibernateCriteriaBuilder.duration
(long magnitude, TemporalUnit unit) A literalDuration
, for example, "five days" or "30 minutes".HibernateCriteriaBuilder.durationByUnit
(TemporalUnit unit, Expression<Duration> duration) Convert aDuration
to a numeric magnitude in the given units.<T extends TemporalAccessor>
JpaFunction<T>HibernateCriteriaBuilder.truncate
(Expression<T> datetime, TemporalUnit temporalUnit) Truncates a date, time or datetime expression to the givenTemporalUnit
. -
Uses of TemporalUnit in org.hibernate.query.criteria.spi
Methods in org.hibernate.query.criteria.spi with parameters of type TemporalUnitModifier and TypeMethodDescriptionHibernateCriteriaBuilderDelegate.duration
(long magnitude, TemporalUnit unit) HibernateCriteriaBuilderDelegate.durationByUnit
(TemporalUnit unit, Expression<Duration> duration) <T extends TemporalAccessor>
JpaFunction<T>HibernateCriteriaBuilderDelegate.truncate
(Expression<T> datetime, TemporalUnit temporalUnit) -
Uses of TemporalUnit in org.hibernate.query.sqm.internal
Methods in org.hibernate.query.sqm.internal with parameters of type TemporalUnitModifier and TypeMethodDescriptionSqmCriteriaNodeBuilder.duration
(long magnitude, TemporalUnit unit) SqmCriteriaNodeBuilder.durationByUnit
(TemporalUnit unit, Expression<Duration> duration) <T extends TemporalAccessor>
SqmFunction<T>SqmCriteriaNodeBuilder.truncate
(Expression<T> datetime, TemporalUnit temporalUnit) -
Uses of TemporalUnit in org.hibernate.query.sqm.tree.expression
Methods in org.hibernate.query.sqm.tree.expression that return TemporalUnitModifier and TypeMethodDescriptionConversion.getUnit()
SqmDurationUnit.getUnit()
SqmExtractUnit.getUnit()
Constructors in org.hibernate.query.sqm.tree.expression with parameters of type TemporalUnitModifierConstructorDescriptionConversion
(Duration duration, TemporalUnit unit, BasicValuedMapping type) SqmDurationUnit
(TemporalUnit unit, ReturnableType<T> type, NodeBuilder nodeBuilder) SqmExtractUnit
(TemporalUnit unit, ReturnableType<T> type, NodeBuilder nodeBuilder) -
Uses of TemporalUnit in org.hibernate.sql.ast.spi
Methods in org.hibernate.sql.ast.spi with parameters of type TemporalUnitModifier and TypeMethodDescriptionprotected void
AbstractSqlAstTranslator.renderIntervalLiteral
(Literal literal, TemporalUnit unit) -
Uses of TemporalUnit in org.hibernate.sql.ast.tree.expression
Methods in org.hibernate.sql.ast.tree.expression that return TemporalUnitModifier and TypeMethodDescriptionDuration.getUnit()
DurationUnit.getUnit()
ExtractUnit.getUnit()
Constructors in org.hibernate.sql.ast.tree.expression with parameters of type TemporalUnitModifierConstructorDescriptionDuration
(Expression magnitude, TemporalUnit unit, BasicValuedMapping type) DurationUnit
(TemporalUnit unit, BasicValuedMapping type) ExtractUnit
(TemporalUnit unit, BasicValuedMapping type)