Home » SQL & PL/SQL » SQL & PL/SQL » what is utc and gmt (Oracle 12c)
what is utc and gmt [message #677315] Wed, 11 September 2019 09:42 Go to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Dear All,

What is UTC and GMT.

How to convert IST date to GMT and UTC.

Thank you.
Re: what is utc and gmt [message #677316 is a reply to message #677315] Wed, 11 September 2019 09:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
UTC is UTC, there is nothing more to say other than that many people refer to it as Zulu Time.

GMT is ambiguous. Some people use it as a synonym for UTC, others use it to refer to the time in the UK (which is currently Zulu +1) so it is probably better to avoid it.
Re: what is utc and gmt [message #677317 is a reply to message #677315] Wed, 11 September 2019 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL> with
  2    data as (
  3      select to_timestamp_tz('2015-09-11 Asia/Calcutta','YYYY-MM-DD TZR') dt from dual
  4    )
  5  select dt, dt at time zone 'UTC' utcdt, dt at time zone 'GMT' gmtdt
  6  from data
  7  /
DT                                    UTCDT                       GMTDT
------------------------------------- --------------------------- ---------------------------
11/09/2015 00:00:00.000 ASIA/CALCUTTA 10/09/2015 18:30:00.000 UTC 10/09/2015 18:30:00.000 GMT
Re: what is utc and gmt [message #677327 is a reply to message #677317] Thu, 12 September 2019 06:26 Go to previous message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Thank you very much Michel Sir. It's working.
Previous Topic: View not pulling with updated table information
Next Topic: Sql query to group the values in comma seperated values
Goto Forum:
  


Current Time: Thu Mar 28 13:24:42 CDT 2024