Gets the week number within a year of a timestamp (a value from 1 to 53). The week number is as defined by ISO 8601: Weeks start on a Monday and belong to the year which contains Thursday (or, equivalently, contains the majority of the week days).

ParameterTypeRequiredDefaultDescription
asstringfalse_weekOfYearThe name of the output field.
fieldstringfalse@timestampThe name of the input field.
timezonestringfalse The name of the timezone to use, if not specified the query's timezone will be used.
timezoneFieldstringfalse@timezoneThe name of the field containing the timezone to use, if not specified the query's timezone will be used. This is ignored if the timezone parameter is passed as well. If this is not defined the timezone offset of the query will be used.