v.21.6Improvement
Function now64 Supports Optional Timezone Argument
Function now64 now supports optional timezone argument. #24091 (Vasily Nemkov).Why it matters
This enhancement allows users to specify a timezone when calling thenow64 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 callingnow64. For example:SELECT now64('Europe/Moscow');This returns the current timestamp in the specified timezone.