Back to Playground Home

Return the day of the year from a timestamp (epoch millis)

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