ROUND_YEAR
Description
This function rounds a DATE input down to the year by setting its MONTH, DAY, HOUR, MINUTE, SECOND and MILLISECOND values to their ground state.
Syntax
ROUND_YEAR ( 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 year: | ||||||||||||||||
| ||||||||||||||||
|