Timezone function doesn't work with Athena
I'm using Athena as a data source, however, I cant use data zone function on it.
SELECT timestamp '2012-10-31 01:00 UTC' AT TIME ZONE 'America/Los_Angeles';
Can anyone help me with this?
Hi Egmont - thanks for writing in and apologies for the delayed response. I just tested your code against our Amazon Athena instance in Mode and it executes correctly. If you are still experiencing this issue and need help, can you please reach out to our success team via in-product chat or email@example.com with a link to the Mode report with that code that isn't working? That way one of our success engineers can help you out.