I want to select all data from last month depends on actually date.
Example: today 2018-06-21 -> I need all datas from 2018-05-01 - 2018-05-31
SELECT * FROM “” WHERE time >= 1525125600000000000 and time <= 1527803999000000000
I will get it. But the Timerange should variable (depends on “today”)
somthing like this:
SELECT * FROM “” WHERE time = month(today)-1
the last 30 days I will get with time < now() - 30d
Is this possible?