Oracle PL/SQL: TIMESTAMP: SYS EXTRACT UTC - SYS EXTRACT UTC extracts the UTC (Coordinated Universal Time

Quick Search:

Oracle PL/SQL: TIMESTAMP: SYS_EXTRACT_UTC

Jump to:

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

<< last

next >>

Snippet Name: TIMESTAMP: SYS_EXTRACT_UTC

Description: SYS_EXTRACT_UTC extracts the UTC (Coordinated Universal Time - formerly Greenwich Mean Time) from a datetime value with time zone offset or time zone region name.

Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» TIMESTAMP: TRUNC
» TIMESTAMP: SysTimeStamp
» TIMESTAMP: SessionTimeZone
» TIMESTAMP: LocalTimestamp
» TIMESTAMP: FROM_TZ
» 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

SYS_EXTRACT_UTC(<date_time WITH timezone>)
 
-- The following example extracts the UTC from a specified 
-- datetime:
 
SELECT SYS_EXTRACT_UTC(TIMESTAMP '2000-03-28 11:30:00.00 -08:00')
   FROM DUAL;
 
SYS_EXTRACT_UTC(TIMESTAMP'2000-03-2811:30:00.00-08:00')
 
28-MAR-00 07.30.00 PM