weekday

Returns the day number of the week from a day/time string.

Example

Return the day number from July 7, 2014 at midnight.

weekday(timestamp("2014-07-07 00:00:00"))

This example returns 2 for Monday.

Syntax

weekday([date | timestamp] expr t)

• t: expression evaluating to a timestamp or date

  Returns

  int

Notes

weekday returns an integer associated with the day of the week, with 1 representing Sunday.