Query get data only to last month on Athena

0

Hi guys, hope you are well!

I need help with a query in athena to get my data for the previous month. In sql I used a query that worked very well and in athena I'm not getting it. My field is coming in yyyymmdd and string format.

The query that I need help for athena to understand is this one:

REF_DATE BETWEEN DATEADD(MONTH, -1,(GETDATE()1DAY(GETDATE())+1)) AND DATEADD(DAY,1,(GETDATE()DAY(GETDATE())+1)))

Thank you so much!

已提问 1 年前125 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容