Skip to main content

TO_START_OF_YEAR

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

Syntax​

TO_START_OF_YEAR(<expr>)

Arguments​

ArgumentsDescription
<expr>date/timestamp

Return Type​

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

Examples​

SELECT to_start_of_year(to_date(18869));
+----------------------------------+
| to_start_of_year(to_date(18869)) |
+----------------------------------+
| 2021-01-01                       |
+----------------------------------+

SELECT to_start_of_year(to_timestamp(1630812366));
+--------------------------------------------+
| to_start_of_year(to_timestamp(1630812366)) |
+--------------------------------------------+
| 2021-01-01                                 |
+--------------------------------------------+