search

starburstdata / metabase-driver

Starburst Metabase driver
Apache License 2.0
60 stars 11 forks source link

convertTimezone returns Function 'converttimezone' not registered #85

Open kempspo opened 1 year ago

kempspo commented 1 year ago

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

leniartek commented 1 year ago

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 commented 1 year ago

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

Related commit