clickhouseConvert datetime to unix timestamp
SELECT toUInt64(toDateTime('2021-11-12 11:12:13'))ctrl + ctoUInt64converts argument to 64-bit integer | toDateTimeconverts string argument to datetime format |
More of Clickhouse
- Using variables in queries
- Create table example
- Create AggregatingMergeTree materialized view
- List all tables from all database
- How to execute SQL query from a file
- Using multiIf in query
- Get total database size
- Inserting data into table example
- Add row number to results
- List all users
See more codes...