v.20.7New Feature
Add FROM_UNIXTIME function for MySQL compatibility
Add FROM_UNIXTIME function for compatibility with MySQL, related to 12149. #12484 (flynn).Why it matters
This feature provides users migrating from MySQL or integrating with MySQL-like environments the ability to use the familiarFROM_UNIXTIME function in ClickHouse, simplifying query compatibility and reducing migration effort.How to use it
Users can use the function by callingFROM_UNIXTIME(timestamp), where timestamp is a Unix timestamp value (seconds since epoch). This will return the corresponding datetime value.