OraFAQ Forum: SQL & PL/SQL » what is utc and gmt

Home » SQL & PL/SQL » SQL & PL/SQL » what is utc and gmt (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is utc and gmt [message #677315]

Wed, 11 September 2019 09:42

sss111ind
Messages: 628
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.

Report message to a moderator

Re: what is utc and gmt [message #677316 is a reply to message #677315]

Wed, 11 September 2019 09:53

John Watson
Messages: 8803
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.

Report message to a moderator

Re: what is utc and gmt [message #677317 is a reply to message #677315]

Wed, 11 September 2019 10:44

Michel Cadot
Messages: 68417
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

Report message to a moderator

Re: what is utc and gmt [message #677327 is a reply to message #677317]

Thu, 12 September 2019 06:26

sss111ind
Messages: 628
Registered: April 2012
Location: India

Senior Member

Thank you very much Michel Sir. It's working.

Report message to a moderator

Previous Topic:	View not pulling with updated table information
Next Topic:	Sql query to group the values in comma seperated values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 06:57:35 CDT 2023