Oracle DATE column - How to convert to UTC I have an oracle 10g table with a DATE column type.  I need to compare it in a where clause to a value generated by a script that looks like this:  TIMESTAMP '2016-05-12 08:00:00.258000 +00:00'.  I cannot control the generated TIMESTAMP part, and when I do:

RECORDEDTIME &gt;= TIMESTAMP '2016-05-12 08:00:00.258000 +00:00' it uses the localtime of the RECORDEDTIME which means I am 4 hours off.  What function do I call on RECORDEDTIME to get it in UTC matching the other value in the WHERE clause (i.e. it needs to subtract 4 hours as I'm in EST)
SYS_EXTRACT_UTC

SQL&gt; 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.000000000 PM