date_extract_woy(...)

date_extract_woy(...)

Extracts the week of the year as an integer between 0 and 51 (inclusive).

Works with the following datatypes:

This function works with 2.1 endpoint(s). What does this mean? »

The date_extract_woy(...) function is used in the $select, $where, or $group parameters to extract Floating Timestamps the week of the year from 0-51 (inclusive). For example, date_extract_woy('2013-10-24T09:33:00.000') would result in 43. This is handy for aggregation & display usages. For example, to aggregate the Chicago Crimes dataset by week of the year:

https://data.cityofchicago.org/resource/6zsd-86xi.json?$select=date_extract_woy(date) as week_of_year, primary_type, count(*)&$group=week_of_year, primary_type