I would like to query the Marketing Cloud _opens table to find any opens in the last 7 days but from the beginning of that given day.
Using the following will get the last 7 days relative to the current time:
select SubscriberKey, EventDate from _opens where EventDate => (s.EventDate > getdate()-7)
pseudo code fyi
So as of now (2018-08-06 15:37:00) it will go back to 2018-07-31 15:37:00 but I want the beginning of the day so its 2018-07-31 00:00:00.