Skip to content

convertTimezone returns Function 'converttimezone' not registered #85

Description

@kempspo

select convertTimezone('2022-12-28T12:00:00', 'UTC', 'US/Pacific') returns the error Query failed (#20230324_063757_02205_u28ez): line 2:13: Function 'converttimezone' not registered

Screenshot 2023-03-24 at 2 39 25 PM
Screenshot 2023-03-24 at 2 40 21 PM

Edit: added additional screenshot to show plugin version

Activity

  1. leniartek commented on Mar 24, 2023

    @leniartek

    Hello @kempspo thanks for reporting issue.
    converttimezone function is not supported by our integration yet.

    This function is not very popular and many other connectors do not support it as well.
    https://www.metabase.com/docs/latest/questions/query-builder/expressions/converttimezone#limitations

    Here you can find workarounds:
    https://www.metabase.com/docs/latest/questions/query-builder/expressions/converttimezone#related-functions

    I can't promise any ETA when this will be taken by our team.

    Do you wan't to prepare PR?

  2. Maiquu commented on May 4, 2023

    @Maiquu
    Contributor

    Isn't convertTimezone already supported? convertTimezone is only available in expression editor, not in SQL editor.

    Related commit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions