◀ Back to Playground HomeReturn the day of the year from a timestamp (epoch millis)select timestamp_field, dayOfYear(timestamp_field, 'UTC') FROM users