Timezone function doesn't work with Athena

Hi,

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?

 

Thanks.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Jonathan Krangeladmin
    • Director - Head of Customer Success @ Mode
    • Jonathan_Krangel
    • 4 mths ago
    • Answer
    • Reported - view

    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 success@modeanalytics.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.

    Thanks!

    Reply Like
Like Follow
  • Status Answered
  • 4 mths agoLast active
  • 1Replies
  • 357Views
  • 2 Following

Create A New Discussion

Share your thoughts