0 - 1 of 1 tags for last month

Hello,
i want my sql script to automatically query the last month (first to last day) in the database.
Like if i am in august 2016 (the day doesn't matter), the query will pick all datassets with date between the 01/07/2016 and the 31/07/2016