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!

已提問 2 年前檢視次數 138 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南