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
- Create table example
- Get total database size
- How to execute SQL query from a file
- List all tables from all database
- Using variables in queries
- List all users
- Alter table query example
- Select countIf usage example
- Create AggregatingMergeTree materialized view
- Select where date column is between dates
See more codes...