Oracle SYS_EXTRACT_UTC

Posted on 11.16.2011 by admin

Function Description

Function SYS_EXTRACT_UTC extracts the UTC or GMT time from a datetime value.

Examples

SELECT SYS_EXTRACT_UTC(TIMESTAMP '2011-11-16 11:30:00 -08:00')
  FROM dual;

Result: 16.11.2011 19:30:00,000000000

SELECT SYS_EXTRACT_UTC(TIMESTAMP '2011-11-16 11:30:00 US/Samoa')
  FROM dual;

Result: 16.11.2011 22:30:00,000000000
This entry was posted in Oracle SQL Functions. Bookmark the permalink.