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 │
└───────────────┘More of Clickhouse
- List all tables from all database
- How to format date/time
- How to delete data
- Select where date column is between dates
- Convert datetime to unix timestamp
- Convert array to rows
- Import CSV data into table from a file
- Create table example
- Get total database size
- Count unique values
See more codes...