clickhouseGet year from date
SELECT toYear(now())ctrl + ctoYearextracts year part from given date/time | now()returns current date/time |
Usage example
SELECT toYear(now())output
┌─toYear(now())─┐
│ 2022 │
└───────────────┘9951 explained code solutions for 126 technologies
SELECT toYear(now())ctrl + ctoYearextracts year part from given date/time | now()returns current date/time |
SELECT toYear(now())┌─toYear(now())─┐
│ 2022 │
└───────────────┘