How to get current GMT in Oracle

sql oracle gmt
user1056038 picture user1056038 · Mar 18, 2012 · Viewed 27.3k times · Source

I'm trying to get the current GMT/UTC regardless of the time zones my current database is located. The possible solution I found is:

SELECT SYSTIMESTAMP AT TIME ZONE dbtimezone FROM DUAL;

and it is giving me the current GMT, but I am not 100% confident if this is the right way. Would anyone please help provide the best way to get the current GMT? Thanks.

Answer

Justin Cave picture Justin Cave · Mar 18, 2012

If you want the current time in GMT, you'd want

SELECT systimestamp AT TIME ZONE 'GMT'
  FROM dual

That will work regardless of the dbtimezone.

Related questions

Time zone conversion in SQL query

I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now I have to convert this to Eastern standard/daylight savings time while retrieving. I am using the below query for …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More