Oracle PL/SQL: TIMESTAMP: FROM TZ - The from tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE va

Quick Search:

Oracle PL/SQL: TIMESTAMP: FROM_TZ

Jump to:

Category: >> Oracle PL/SQL >> TIMESTAMP: FROM_TZ

<< last

next >>

Snippet Name: TIMESTAMP: FROM_TZ

Description: The from_tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.

Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» TIMESTAMP: TRUNC
» TIMESTAMP: SysTimeStamp
» TIMESTAMP: SYS_EXTRACT_UTC
» TIMESTAMP: SessionTimeZone
» TIMESTAMP: LocalTimestamp
» TIMESTAMP: EXTRACT
» TIMESTAMP: DUMP
» TIMESTAMP: DBTIMEZONE
» TIMESTAMP: Get current timestamp
» TIMESTAMP: List time zones

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009

FROM_TZ( timestamp_value, time_zone_value )
 
-- timestamp_value is the value to convert to a 
-- TIMESTAMP WITH TIME ZONE value.
 
-- time_zone_value is the time zone used to convert 
-- timestamp_value to a TIMESTAMP WITH TIME ZONE value.