v.23.8New Feature

New toUTCTimestamp and fromUTCTimestamp Functions Added for ClickHouse

Official CH changelog text
New functions toUTCTimestamp/fromUTCTimestamp to act same as spark's to_utc_timestamp/from_utc_timestamp. #52117 (KevinyhZou).
Introduces new functions toUTCTimestamp and fromUTCTimestamp that replicate the behavior of Spark's to_utc_timestamp and from_utc_timestamp functions.

Why it matters

These functions provide users with a standard way to convert timestamps to and from UTC, matching Spark's semantics, which improves compatibility and ease of migration for users working across both systems.

How to use it

Use the functions toUTCTimestamp and fromUTCTimestamp in your SQL queries to convert timestamps to UTC timezone and from UTC to a specified timezone, respectively.

Related resources

PreviousNext