Athena Date and Time Functions

athena_date_time.sql

-- [SQL Queries, Functions, and Operators](https://docs.aws.amazon.com/athena/latest/ug/functions-operators-reference-section.html)

SELECT
  from_iso8601_timestamp(time) as new_time,
  date_format(from_iso8601_timestamp(time), '%Y') AS year,
  hour(from_iso8601_timestamp(time)) AS hour,
  from_iso8601_timestamp(time) at time zone 'Pacific/Auckland' as nzst_time,
  hour(from_iso8601_timestamp(time) at time zone 'Pacific/Auckland') AS nzst_hour,
  minute(from_iso8601_timestamp(time) at time zone 'Pacific/Auckland') AS nzst_minute,
  *
FROM alb_logs;