date_extract_hh(...)Extracts the hour of the day as an integer between 0 and 23 (inclusive).
Works with the following datatypes:
This function works with 2.1 and 3.0 endpoint(s). What does this mean? »
The date_extract_hh(...) function is used in the $select, $where, or $group parameters to extract Floating Timestamps the hour of the day as a number from 0-23 (inclusive). For example, date_extract_hh('2013-10-24T09:33:00.000') would result in 9. This is handy for aggregation & display usages. For example, to aggregate the Chicago Crimes dataset by hour of the day:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.