SELECT DATE_TRUNC('day', trade_date + INTERVAL '1 DAY') from trade_table;
I have dates that are all on Monday through Friday, but when I date_trunc a date that is on Saturday (e.g. taking weekday plus 1), it is rounded to Saturday. I want it to be rounded to the following Monday rather than Saturday. How can I do that?