EPOCH_MS

1
SELECT
2
  ms_val,
3
  EPOCH_MS(ms_val) as timestamp_val
4
FROM (
5
  SELECT unnest([0, 1718452800000, 946684800000]) as ms_val
6
);

1
SELECT
2
  event_name,
3
  EPOCH_MS(js_timestamp) as event_time
4
FROM js_events;

1
SELECT
2
  original_ts,
3
  CAST(EPOCH(original_ts) * 1000 AS BIGINT) as to_ms,
4
  EPOCH_MS(CAST(EPOCH(original_ts) * 1000 AS BIGINT)) as back_to_ts
5
FROM (SELECT TIMESTAMP '2024-06-15 14:30:45' as original_ts);