◀ Back to Playground Home

Return the hour from a timestamp (epoch millis)

select timestamp_field, hour(timestamp_field, 'UTC')
FROM users