SQL Date Functions: How to Group by Month Without Losing One

DATE_TRUNC, EXTRACT, INTERVAL and the half-open range, worked on sixteen real orders. Includes the month that never becomes a row, and two engines that disagree about 31 January plus one month.