All Products
Search
Document Center

SYS_EXTRACT_UTC

Last Updated: Jun 18, 2021

The SYS_EXTRACT_UTC function returns the standard Coordinated Universal Time (UTC) time that corresponds to the specified time.

Syntax

SYS_EXTRACT_UTC (datetime_with_timezone)
Notice

UTC is short for Coordinated Universal Time. The UTC and Greenwich Mean Time (GMT) are the same as the local time in London, UK.

Parameters

Parameter

Description

datetime_with_timezone

The values of the TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types.

Return type

TIMESTAMP data type

Examples

Execute the following statement:

SELECT SYS_EXTRACT_UTC(TIMESTAMP '2020-03-28 11:30:00.00 -08:00')
FROM DUAL;

The following query result is returned:

+---------------------------------------------------------+
| SYS_EXTRACT_UTC(TIMESTAMP'2020-03-2811:30:00.00-08:00') |
+---------------------------------------------------------+
| 2020-03-28 19:30:00.000000000                           |
+---------------------------------------------------------+