toStartOfInterval

Function: toStartOfInterval()

toStartOfInterval(field, interval, alias?): SqlExpression | AliasedExpression

Truncates a date/time value to the start of the specified interval

Parameters

field

string

The field to truncate

interval

string

The interval (e.g., ‘1 day’, ‘15 minute’)

alias?

string

Optional alias for the result

Returns

SqlExpression | AliasedExpression

SQL expression or aliased expression