◀ Back to Playground Home

Return the year from a timestamp (epoch millis)

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