Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 121 of 166
sys_extract_utc::=
sys_extract_utc
The SYS_EXTRACT_UTC
function extracts the UTC (Coordinated Universal Time--formerly Greenwich Mean Time) from a datetime with time zone displacement.
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|