TO_MONDAY
Rounds down a date or date with time (timestamp/datetime) to the nearest Monday. Returns the date.
Syntax
to_monday( <expr> )
Arguments
| Arguments | Description |
|---|---|
<expr> | date/timestamp |
Return Type
UInt16 datatype.
Examples
SELECT to_monday(now());
+------------------+
| to_monday(now()) |
+------------------+
| 19079 |
+------------------+
SELECT to_date(to_monday(now()));
+---------------------------+
| to_date(to_monday(now())) |
+---------------------------+
| 2022-03-28 |
+---------------------------+
SELECT to_monday(to_timestamp(1630812366));
+-------------------------------------+
| to_monday(to_timestamp(1630812366)) |
+-------------------------------------+
| 18869 |
+-------------------------------------+