Skip navigation links

oracle.olapi.syntax
Class TimeZoneExpression

java.lang.Object
oracle.olapi.syntax.SyntaxObject
oracle.olapi.syntax.DataObject
oracle.olapi.syntax.Expression
oracle.olapi.syntax.TypedExpression
oracle.olapi.syntax.RowExpression
oracle.olapi.syntax.TimeZoneExpression

All Implemented Interfaces:

FunctionArgument

public final class TimeZoneExpression

extends RowExpression

A RowExpression that represents a date with a time zone. A TimeZoneExpression is similar to a SQL datetime expression that specifies a time zone.

Constructor Summary

TimeZoneExpression(TypedExpression dateExpression, TypedExpression timezoneExpression)
Creates a TimeZoneExpression with the specified date and time zone.

Method Summary

TypedExpression	getDateExpression() Gets the date expression that is associated with this TimeZoneExpression.
TypedExpression	getTimeZoneExpression() Gets the time zone expression that is associated with this TimeZoneExpression.
java.lang.Object	visit(SyntaxObjectVisitor visitor, java.lang.Object context) Calls the visitTimeZoneExpression method of the SyntaxObjectVisitor and passes that method this TimeZoneExpression and an Object.

Methods inherited from class oracle.olapi.syntax.RowExpression

isCompositeObject

Methods inherited from class oracle.olapi.syntax.TypedExpression

abs, acos, addMonths, addMonths, ascii, asciiStr, asin, atan, atan2, between, binToNum, bitAnd, cast, ceil, charToROWID, chr, chr, coalesce, compose, concat, concat, convert, convert, cos, cosh, currentDate, currentTime, dbTimeZone, decode, decompose, deref, div, div, div, div, div, dump, eq, eq, eq, eq, eq, exp, extractDay, extractHour, extractMinute, extractMonth, extractSecond, extractTimeZoneAbbr, extractTimeZoneHour, extractTimeZoneMinute, extractTimeZoneRegion, extractYear, floor, fromTZ, ge, ge, ge, ge, ge, getDataType, greatest, gt, gt, gt, gt, gt, hexToRAW, in, initcap, instr, instr2, instr4, instrB, instrC, isInfinite, isNAN, isNotNull, isNull, lastDay, le, le, le, le, le, least, length, length2, length4, lengthB, lengthC, like, like, like2, like4, likeC, ln, localTimestamp, log, lower, lpad, lt, lt, lt, lt, lt, ltrim, minus, minus, minus, minus, minus, minus, mod, monthsBetween, nanvl, ne, ne, ne, ne, ne, newTime, nextDay, nlsCharsetDeclLen, nlsCharsetID, nlsCharsetName, nlsInitcap, nlsLower, nlsSort, nlsUpper, notIn, nullIf, numToDSInterval, numToYMInterval, nvl, nvl2, oraHash, plus, plus, plus, plus, plus, power, rawToHex, rawToNHex, regexpInstr, regexpReplace, regexpSubstr, remainder, replace, round, rowIDToChar, rowIDToNChar, rpad, rtrim, scnToTimestamp, sessionTimeZone, sign, sin, sinh, soundex, sqrt, substr, substr2, substr4, substrB, substrC, sysContext, sysDate, sysExtractUTC, sysGUID, sysTimestamp, sysTypeID, tan, tanh, times, times, times, times, times, timestampToSCN, toBinaryDouble, toBinaryFloat, toChar, toChar, toCLOB, toDate, toDate, toDSInterval, toLOB, toMultiByte, toNChar, toNChar, toNCLOB, toNumber, toNumber, toNumber, toSingleByte, toTimestamp, toTimestampTZ, toYMInterval, translate, translateUsingCharCS, translateUsingNCharCS, treat, trim, trimLeading, trimTrailing, trunc, tzOffset, UID, unistr, upper, USER, userEnv, vsize, widthBucket

Methods inherited from class oracle.olapi.syntax.SyntaxObject

equals, equals, fromSyntax, fromSyntax, fromSyntax, fromSyntax, fromSyntax, isValid, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax

Methods inherited from class java.lang.Object

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

Constructor Detail

TimeZoneExpression

public TimeZoneExpression(TypedExpression dateExpression,
                          TypedExpression timezoneExpression)

Creates a TimeZoneExpression with the specified date and time zone. The timezoneExpression parameter is a TypedExpression that resolves to one of the following expressions.

Values for timezoneExpression	Description
AT LOCAL	The time zone of the current session.
AT TIME ZONE expression	If expression is the string '(+|-)HH:MM', then the time zone is an offset from UTC. If expression is a time zone name, then the TimeZoneExpression resolves to the datetime value in the indicated time zone.
AT TIME ZONE DBTIMEZONE	The database time zone established (explicitly or by default) during database creation.
AT TIME ZONE SESSIONTIMEZONE	The session time zone established by default or in the most recent SQL ALTER SESSION statement.

If the timezoneExpression parameter is null, then this method uses the AT LOCAL expression.

For more information, see Datetime Expressions in Oracle Database SQL Language Reference.

Parameters:

dateExpression - A TypedExpression that has a data type that is in the DataType.DATETIME_CATEGORY category of data types.

timezoneExpression - A TypedExpression that resolves to an AT ... clause of a SQL datetime expression.

Method Detail

visit

public java.lang.Object visit(SyntaxObjectVisitor visitor,
                              java.lang.Object context)

Calls the visitTimeZoneExpression method of the SyntaxObjectVisitor and passes that method this TimeZoneExpression and an Object.

Specified by:

visit in class SyntaxObject

Parameters:

visitor - A SyntaxObjectVisitor.

context - An Object.

Returns:

The Object returned by the visitTimeZoneExpression method.

getDateExpression

public TypedExpression getDateExpression()

Gets the date expression that is associated with this TimeZoneExpression.

Returns:

A TypedExpression that resolves to the datetime value of this TimeZoneExpression.

getTimeZoneExpression

public TypedExpression getTimeZoneExpression()

Gets the time zone expression that is associated with this TimeZoneExpression.

Returns:

A TypedExpression that resolves to the time zone specification of this TimeZoneExpression.

Skip navigation links