v.20.10Improvement

Function now accepts timezone argument, closing issue 15264

Official CH changelog text
The function now allows an argument with timezone. This closes 15264. #15285 (flynn).
now function supports a timezone argument.

Why it matters

This feature allows users to obtain the current time adjusted to a specified timezone, enhancing flexibility in time-related queries and data processing. It solves the limitation of now returning the current time only in the server's local timezone.

How to use it

Use the now function with a timezone string argument, for example:

SELECT now('Europe/Moscow')

This will return the current time in the specified timezone instead of the server's local time.

Related resources

PreviousNext