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

Copyright © 2003, 2007, Oracle. All rights reserved.