v.25.8New Feature

Add a new

Official CH changelog text
Added a new function nowInBlock64. Example usage: SELECT nowInBlock64(6) returns 2025-07-29 17:09:37.775725. #84178 (Halersson Paris).
Introduced the new function nowInBlock64 to return the current timestamp with microsecond precision as a 64-bit integer.

Why it matters

The function provides a high-precision, compact representation of the current time within a block. This is useful for scenarios requiring precise time measurement or storage efficiency compared to datetime types.

How to use it

Use the function in a query by calling <code>SELECT nowInBlock64(precision)</code>, where precision specifies the decimal places for fractional seconds (e.g., 6 for microseconds). For example:

SELECT nowInBlock64(6)

Related resources

PreviousNext