fbpx
Select Page

Function Index

Date Functions

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

Converts a UTC date to a different time zone.
Adds the specified quantity of time to a date.
Calculates the time difference between two dates.
Convert a Unix-style timestamp (seconds since January 1, 1970) to a Date.
Extract the specified date part, e.g. “month”, from the given date.
Convert the value into a date and time.
Truncate the date to the specified date part, e.g.”month”.
Returns the day of the month of the given date as a number.
Returns the hour component of the given date as a number.
Makes a date from the given year, month, and day of the month.
Returns the minute component of the given date as a number.
Returns the month component of the given date as a number.
Returns the current UTC date and time.
Returns the quarter component of the given date, as a number.
Returns the second component of the given date as a number.
Returns the current UTC date.
Returns the day of the week as Sunday (1) to Saturday (7).
Returns the year component of the given date as a number.

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