◀ Back to Playground Home

Return the distinct years from a timestamp (epoch millis)

select DISTINCT year(timestamp_field, 'UTC')
FROM users
LIMIT 1000