convertTimezone returns Function 'converttimezone' not registered

[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

Edit: added additional screenshot to show plugin version

[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?

[Maiquu]

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

Related commit