Skip to content

Support at_timezone(timestamp with time zone, interval day to second) function signature in Presto C++ #26666

@pramodsatya

Description

@pramodsatya

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.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions