Skip to main content

TO_MONDAY

Rounds down a date or date with time to the nearest Monday. Returns the date.

Syntax​

to_monday( <expr> )

Arguments​

ArgumentsDescription
<expr>date/datetime

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_datetime(1630812366));
+----------------------------------+
| to_monday(to_datetime(1630812366)) |
+----------------------------------+
|                            18869 |
+----------------------------------+