'Converting UTC to GMT

I would like to convert a UNIX figure in to a GMT timestamp.

I first convert the UNIX number to UTC, but cannot seem to convert it to GMT?

For Example

Date UNIX Event_Unix_Timestamp Country
2022-03-10 1646899782 2022-03-10 08:09:42 UTC Nigeria

The query I currently have is :

SELECT 
   DATE 
  , EVENTUNIX
  , TIMESTAMP_SECONDS (EventUNIX) AS Event_Unix_Timestamp
  , COUNTRY
FROM TABLE
GROUP BY 1,2,3

I have tried the below function:

TIMESTAMP (DATETIME(TIMESTAMP_SECONDS(EventUNIX) , "Europe/London") ) AS Video_Event_Unix_Timestamp 

and with 'GMT'
 

But this doesn't work.

Any help would be great! Thanks!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source