'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 |
|---|
