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 |
+---------------------------------------------------------+