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!

asked a year ago114 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions