date_trunc_ym(...)Truncates a calendar date at the year/month threshold
Works with the following datatypes:
This function works with 2.0, 2.1, and 3.0 endpoint(s). What does this mean? »
The date_trunc_ym(...) function is used in the $select, $where, or $group parameters to truncate Floating Timestamps at the year and month level. For example, date_trunc_ym('2012-09-22T18:05:00.000') would result in new timestamp of '2012-09-01T00:00:00.000'. This is handy for aggregation & display usages. For example, to aggregate the Chicago Crimes dataset by month:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.