v.21.6Improvement

Function now64 Supports Optional Timezone Argument

Function now64 now supports optional timezone argument. #24091 (Vasily Nemkov).
Function now64 now supports an optional timezone argument.

Why it matters

This enhancement allows users to specify a timezone when calling the now64 function, enabling retrieval of current timestamps adjusted to the desired timezone. This improves flexibility and accuracy when working with time-sensitive data across different time zones.

How to use it

To use this feature, provide the optional timezone argument as a string when calling now64. For example:

SELECT now64('Europe/Moscow');

This returns the current timestamp in the specified timezone.