ROUND_WEEK
Description
This function rounds a DATE input down to the week by setting its HOUR, MINUTE, SECOND and MILLISECOND values to their ground state. The DAY value is set to the Monday of the week of that date.
Syntax
ROUND_WEEK ( table.date_column )
NULL handling
If the input value is NULL, then the result is NULL as well.
Example
[1] Round dates down to the week: | ||||||||||||||||
| ||||||||||||||||
|