Truncate dates to the start of a period with DATETRUNC — SQL Server syntax, SQLite truncation including quarters, grouping by month, year and week, comparing truncated dates, and truncation versus strftime.
Loading content...