Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

FROM_TZ

FROM_TZ converts a timestamp value and a time zone to a TIMESTAMP WITH TIME ZONE data type.

Return Value

TIMESTAMP WITH TIME ZONE

Syntax

FROM_TZ (timestamp_value, time_zone_value)

Arguments

timestamp_value is an expression with a TIMESTAMP data type.

time_zone_value is a text expression that returns a string in the format TZH:TZM or in TZR with optional TZD format.

Example

FROM_TZ(TIMESTAMP '2008-03-26 08:00:00', '3:00') returns the value 26-MAR-08 08.00.00.000000 AM +03:00.