Skip to main content

toMonday

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

Syntax​

toMonday(expr)

Arguments​

ArgumentsDescription
exprdate16/date32/datetime

Return Type​

UInt16 datatype.

Examples​

mysql> select toMonday(now());
+-----------------+
| tomonday(now()) |
+-----------------+
|           19079 |
+-----------------+

mysql> select todate(toMonday(now()));
+-------------------------+
| todate(toMonday(now())) |
+-------------------------+
| 2022-03-28              |
+-------------------------+

mysql> select toMonday(toDateTime(1630812366));
+----------------------------------+
| toMonday(toDateTime(1630812366)) |
+----------------------------------+
|                            18869 |
+----------------------------------+