Presto function at_timezone supports signature at_timezone(timestamp with time zone, interval day to second) (reference). Presto C++ does not support this function signature and it needs to be added in Velox.
Expected Behavior or Use Case
The query:
SELECT TIMESTAMP '2012-10-31 01:00' AT TIME ZONE INTERVAL '07:09' hour to minute
should return:
2012-10-30 18:09:00.000 +07:09
Currently in Presto C++ clusters with sidecar, this query fails with error:
Unexpected parameters (timestamp with time zone, interval day to second) for function native.default.at_timezone
Context
Presto native tests: testAtTimeZoneWithInterval() testcase in AbstractTestQueries.