Back to feed
Dev.to
Dev.to
7/23/2026
Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

Short summary

ClickHouse 26.3 adds support for ANSI SQL standard time functions like CURRENT_DATE, CURRENT_TIMESTAMP, and NOW without parentheses, improving portability for migrations from PostgreSQL, MySQL, and other databases. The native functions today() and now() remain fully supported and recommended. This change reduces rewrite effort for BI tools like Superset, Tableau, and Power BI that generate ANSI SQL automatically.

  • •ClickHouse 26.3 supports CURRENT_DATE, CURRENT_TIMESTAMP, and NOW without parentheses
  • •Native functions today() and now() remain supported and recommended
  • •Improves migration from PostgreSQL, MySQL, Oracle, Snowflake and BI tool compatibility

Generated with AI, which can make mistakes.

#ai-tools#open-source
Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

ClickHouse 26.6 latest update
Dev.to
The original headline is: "ClickHouse 26.3 Removes Experimental Hypothesis Skip Index: Migration Guide"
Dev.to
Day 21 : Time-Series Data in ClickHouse®
Dev.to
Day 25 of 100 Days of ClickHouse: Mastering the ClickHouse HTTP API
Dev.to