EPOCH

1
SELECT
2
  ts,
3
  EPOCH(ts) as epoch_seconds
4
FROM (
5
  SELECT TIMESTAMP '1970-01-01 00:00:00' as ts UNION ALL
6
  SELECT TIMESTAMP '2024-06-15 12:00:00' UNION ALL
7
  SELECT TIMESTAMP '2000-01-01 00:00:00'
8
);

1
SELECT
2
  start_time,
3
  end_time,
4
  EPOCH(end_time) - EPOCH(start_time) as duration_seconds,
5
  (EPOCH(end_time) - EPOCH(start_time)) / 60 as duration_minutes
6
FROM tasks;

1
SELECT
2
  epoch_val,
3
  TO_TIMESTAMP(epoch_val) as timestamp_val
4
FROM (
5
  SELECT unnest([0, 1718452800, 946684800]) as epoch_val
6
);