TO_START_OF_ISO_YEAR

Returns the first day of the ISO year for a date or a date with time (timestamp/datetime).

Syntax

TO_START_OF_ISO_YEAR(<expr>)

Arguments

Arguments	Description
<expr>	date/timestamp

Return Type

DATE, returns date in “YYYY-MM-DD” format.

Examples

SELECT to_start_of_iso_year(to_date(18869));
+--------------------------------------+
| to_start_of_iso_year(to_date(18869)) |
+--------------------------------------+
| 2021-01-04                           |
+--------------------------------------+

SELECT to_start_of_iso_year(to_timestamp(1630812366));
+------------------------------------------------+
| to_start_of_iso_year(to_timestamp(1630812366)) |
+------------------------------------------------+
| 2021-01-04                                     |
+------------------------------------------------+