Class TimeZoneOperation

java.lang.Object

org.h2.expression.Expression

org.h2.expression.Operation1_2

org.h2.expression.TimeZoneOperation

All Implemented Interfaces:

HasSQL, Typed

public final class TimeZoneOperation
extends Operation1_2

A time zone specification (AT { TIME ZONE | LOCAL }).

Field Summary

Fields inherited from class Operation1_2

left, right, type

Fields inherited from class Expression

AUTO_PARENTHESES, MAP_IN_AGGREGATE, MAP_IN_WINDOW, MAP_INITIAL, WITH_PARENTHESES, WITHOUT_PARENTHESES

Fields inherited from interface HasSQL

ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS

Constructor Summary

Constructors

Constructor	Description
TimeZoneOperation(Expression left, Expression right)

Method Summary

Modifier and Type	Method	Description
StringBuilder	getUnenclosedSQL(StringBuilder builder, int sqlFlags)	Get the SQL statement of this expression.
Value	getValue(SessionLocal session)	Return the resulting value for the current row.
Expression	optimize(SessionLocal session)	Try to optimize the expression.
static int	parseInterval(Value interval)	Parses a daytime interval as time zone offset.
private static int	parseTimeZone(Value b, long dateValue, long timeNanos, int offsetSeconds, boolean allowTimeZoneName)

Methods inherited from class Operation1_2

getCost, getSubexpression, getSubexpressionCount, getType, isEverything, mapColumns, setEvaluatable, updateAggregate

Methods inherited from class Expression

addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNotIfPossible, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getTableAlias, getTableName, getWhenSQL, getWhenValue, isConstant, isIdentity, isNullConstant, isValueSet, isWhenConditionOperand, needParentheses, optimizeCondition, toString, writeExpressions, writeExpressions

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface HasSQL

getTraceSQL

Constructor Details

TimeZoneOperation

public TimeZoneOperation(Expression left,
 Expression right)

Method Details

getUnenclosedSQL

public StringBuilder getUnenclosedSQL(StringBuilder builder,
 int sqlFlags)

Description copied from class: Expression

Get the SQL statement of this expression. This may not always be the original SQL statement, especially after optimization. Enclosing '(' and ')' are never appended.

Specified by:

getUnenclosedSQL in class Expression

Parameters:

builder - string builder

sqlFlags - formatting flags

Returns:

the specified string builder

getValue

public Value getValue(SessionLocal session)

Description copied from class: Expression

Return the resulting value for the current row.

Specified by:

getValue in class Expression

Parameters:

session - the session

Returns:

the result

parseTimeZone

private static int parseTimeZone(Value b,
 long dateValue,
 long timeNanos,
 int offsetSeconds,
 boolean allowTimeZoneName)

parseInterval

public static int parseInterval(Value interval)

Parses a daytime interval as time zone offset.

Parameters:

interval - the interval

Returns:

the time zone offset in seconds

optimize

public Expression optimize(SessionLocal session)

Description copied from class: Expression

Try to optimize the expression.

Specified by:

optimize in class Expression

Parameters:

session - the session

Returns:

the optimized expression