Sys_extract_utc – Oracle SQL Function

SYS_EXTRACT_UTC returns the Cordinated Universal Time from a datetime string including a time zone code or offset.

Example:

SELECT SYS_EXTRACT_UTC(TIMESTAMP ‘2004-10-23 10:25:00.00 EST’) as RESULT FROM DUAL;

RESULT
—————-
23-OCT-04 02.25.00.000000000 PM