Skip navigation links

Oracle® OLAP Java API Reference
11g Release 2 (11.2)

E10794-05


oracle.olapi.syntax
Class TimeZoneExpression

java.lang.Object
  extended by oracle.olapi.syntax.SyntaxObject
      extended by oracle.olapi.syntax.DataObject
          extended by oracle.olapi.syntax.Expression
              extended by oracle.olapi.syntax.TypedExpression
                  extended by oracle.olapi.syntax.RowExpression
                      extended by 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

Copyright © 2002, 2010, Oracle. All rights reserved.