DATE_TRUNC()

Concepts: sqlDateTrunc

Truncating to Common Units Truncate to day, week, month, or year to group timestamps into buckets for aggregation. Grouping by Time Period Week Starts The truncated timestamp also works as an X-axis value in charts without additional formatting, making it ideal for time-series visualizations in BI tools.