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
- Using variables in queries
- List all tables from all database
- Get total database size
- Convert string to date/time
- How to execute SQL query from a file
- Select where date column is between dates
- Create table example
- Remove column from a table
- Show running queries
- List all users
See more codes...