v.23.7New Feature

Add Function Aliases for today and now in ClickHouse

Official CH changelog text
Add alias for functions today (now available under the curdate/current_date names) and now (current_timestamp). #52106 (Lloyd-Pottiger).
Adds new aliases for existing date and time functions: today is now accessible as curdate and current_date, and now is also available as current_timestamp.

Why it matters

This feature enhances usability and compatibility by providing alternative names for commonly used date and time functions, making it easier for users coming from other SQL environments to write queries and improving code readability.

How to use it

Use the aliases curdate or current_date as substitutes for today, and current_timestamp as a substitute for now in your SQL queries. For example:

SELECT <code>curdate</code>(), <code>current_timestamp</code>()
FROM system.one

Related resources

PreviousNext