I need a Vertica statement to extract the prior week's data Sun - Sat. For example, if today is 12/2/2021, I need all dates between Sunday, Nov 21st and Saturday, Nov 27th (Sun-Sat)
Select aux_date from data
where aux_date between Nov 21 and Nov 27
I can't seem to figure this out for Vertica?