Select Page

Truncate the date to the specified date part, e.g.”month”.


DateTrunc(<precision>, <date>, <timezone>)

precision (required) Smallest date part to preserve, chosen from “year”, “month”, “week”, “day”, “hour”, “minute”, and “second”.

date (required) Date to be truncated.

timezone (optional) Name of IANA timezone to get the date part at, e.g.”America/Los_Angeles”. When calculating a timezone, input dates are treated as UTC.


DateTrunc(“hour”, Date(“1980-05-22 8:45:30”))
  • Returns 1980-05-22 8:00:00 discarding the “minute” and”second” components of the date.
DateTrunc(“day”, Date(“1980-05-22 8:45:30”))
  • Returns 1980-05-22 00:00:00 discarding the time components of the date.

More About Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.