By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| previous_wednesday | previous_thursday |
|---|---|
| 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
SELECT 1
| to_char | previous_wednesday | previous_thursday |
|---|---|---|
| 2024-01-15, Monday | 2024-01-10 | 2024-01-11 |
| 2024-01-16, Tuesday | 2024-01-10 | 2024-01-11 |
| 2024-01-17, Wednesday | 2024-01-10 | 2024-01-11 |
| 2024-01-18, Thursday | 2024-01-17 | 2024-01-11 |
| 2024-01-19, Friday | 2024-01-17 | 2024-01-18 |
| 2024-01-20, Saturday | 2024-01-17 | 2024-01-18 |
| 2024-01-21, Sunday | 2024-01-17 | 2024-01-18 |
SELECT 7
| to_char | previous_wednesday | previous_thursday |
|---|---|---|
| 2024-01-15, Monday | 2024-01-10 | 2024-01-11 |
| 2024-01-16, Tuesday | 2024-01-10 | 2024-01-11 |
| 2024-01-17, Wednesday | 2024-01-10 | 2024-01-11 |
| 2024-01-18, Thursday | 2024-01-17 | 2024-01-11 |
| 2024-01-19, Friday | 2024-01-17 | 2024-01-18 |
| 2024-01-20, Saturday | 2024-01-17 | 2024-01-18 |
| 2024-01-21, Sunday | 2024-01-17 | 2024-01-18 |
SELECT 7
| to_char | previous_wednesday | previous_thursday |
|---|---|---|
| 2024-01-15, Monday | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-16, Tuesday | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-17, Wednesday | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-18, Thursday | 2024-01-17 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-19, Friday | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
| 2024-01-20, Saturday | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
| 2024-01-21, Sunday | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
SELECT 7
ERROR: syntax error at or near "days" LINE 3: date_trunc('week', dt + interval '-3' days) + interval '2' d... ^