v.23.9Improvement

Add addDate and subDate functions for MySQL compatibility and consistency

Official CH changelog text
Add addDate function for compatibility with MySQL and subDate for consistency. Reference #54275. #54400 (Nikolay Degterinsky).
Introduces the addDate function for MySQL compatibility and the subDate function for consistent date arithmetic operations in ClickHouse.

Why it matters

To provide users with familiar date manipulation functions similar to MySQL, improving ease of migration and ensuring consistent behavior when adding or subtracting date intervals.

How to use it

Use addDate to add date intervals and subDate to subtract date intervals in SQL queries. Example usage: SELECT addDate('day', 3, today()); or SELECT subDate('month', 1, today());.

Related resources

PreviousNext