By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Dt | WeekDay | DayDiff | BucketNo | BucketDay | BucketStartDt | BucketEndDt |
---|---|---|---|---|---|---|
2023-09-01 13:45:00.000 | Friday | -31 | -3 | 11 | 2023-08-21 | 2023-09-03 |
2023-09-02 13:45:00.000 | Saturday | -30 | -3 | 12 | 2023-08-21 | 2023-09-03 |
2023-09-03 13:45:00.000 | Sunday | -29 | -3 | 13 | 2023-08-21 | 2023-09-03 |
2023-09-04 13:45:00.000 | Monday | -28 | -2 | 0 | 2023-09-04 | 2023-09-17 |
2023-09-05 13:45:00.000 | Tuesday | -27 | -2 | 1 | 2023-09-04 | 2023-09-17 |
2023-09-06 13:45:00.000 | Wednesday | -26 | -2 | 2 | 2023-09-04 | 2023-09-17 |
2023-09-07 13:45:00.000 | Thursday | -25 | -2 | 3 | 2023-09-04 | 2023-09-17 |
2023-09-08 13:45:00.000 | Friday | -24 | -2 | 4 | 2023-09-04 | 2023-09-17 |
2023-09-09 13:45:00.000 | Saturday | -23 | -2 | 5 | 2023-09-04 | 2023-09-17 |
2023-09-10 13:45:00.000 | Sunday | -22 | -2 | 6 | 2023-09-04 | 2023-09-17 |
2023-09-11 13:45:00.000 | Monday | -21 | -2 | 7 | 2023-09-04 | 2023-09-17 |
2023-09-12 13:45:00.000 | Tuesday | -20 | -2 | 8 | 2023-09-04 | 2023-09-17 |
2023-09-13 13:45:00.000 | Wednesday | -19 | -2 | 9 | 2023-09-04 | 2023-09-17 |
2023-09-14 13:45:00.000 | Thursday | -18 | -2 | 10 | 2023-09-04 | 2023-09-17 |
2023-09-15 13:45:00.000 | Friday | -17 | -2 | 11 | 2023-09-04 | 2023-09-17 |
2023-09-16 13:45:00.000 | Saturday | -16 | -2 | 12 | 2023-09-04 | 2023-09-17 |
2023-09-17 13:45:00.000 | Sunday | -15 | -2 | 13 | 2023-09-04 | 2023-09-17 |
2023-09-18 13:45:00.000 | Monday | -14 | -1 | 0 | 2023-09-18 | 2023-10-01 |
2023-09-19 13:45:00.000 | Tuesday | -13 | -1 | 1 | 2023-09-18 | 2023-10-01 |
2023-09-20 13:45:00.000 | Wednesday | -12 | -1 | 2 | 2023-09-18 | 2023-10-01 |
2023-09-21 13:45:00.000 | Thursday | -11 | -1 | 3 | 2023-09-18 | 2023-10-01 |
2023-09-22 13:45:00.000 | Friday | -10 | -1 | 4 | 2023-09-18 | 2023-10-01 |
2023-09-23 13:45:00.000 | Saturday | -9 | -1 | 5 | 2023-09-18 | 2023-10-01 |
2023-09-24 13:45:00.000 | Sunday | -8 | -1 | 6 | 2023-09-18 | 2023-10-01 |
2023-09-25 13:45:00.000 | Monday | -7 | -1 | 7 | 2023-09-18 | 2023-10-01 |
2023-09-26 13:45:00.000 | Tuesday | -6 | -1 | 8 | 2023-09-18 | 2023-10-01 |
2023-09-27 13:45:00.000 | Wednesday | -5 | -1 | 9 | 2023-09-18 | 2023-10-01 |
2023-09-28 13:45:00.000 | Thursday | -4 | -1 | 10 | 2023-09-18 | 2023-10-01 |
2023-09-29 13:45:00.000 | Friday | -3 | -1 | 11 | 2023-09-18 | 2023-10-01 |
2023-09-30 13:45:00.000 | Saturday | -2 | -1 | 12 | 2023-09-18 | 2023-10-01 |
2023-10-01 13:45:00.000 | Sunday | -1 | -1 | 13 | 2023-09-18 | 2023-10-01 |
2023-10-02 13:45:00.000 | Monday | 0 | 0 | 0 | 2023-10-02 | 2023-10-15 |
2023-10-03 13:45:00.000 | Tuesday | 1 | 0 | 1 | 2023-10-02 | 2023-10-15 |
2023-10-04 13:45:00.000 | Wednesday | 2 | 0 | 2 | 2023-10-02 | 2023-10-15 |
2023-10-05 13:45:00.000 | Thursday | 3 | 0 | 3 | 2023-10-02 | 2023-10-15 |
2023-10-06 13:45:00.000 | Friday | 4 | 0 | 4 | 2023-10-02 | 2023-10-15 |
2023-10-07 13:45:00.000 | Saturday | 5 | 0 | 5 | 2023-10-02 | 2023-10-15 |
2023-10-08 13:45:00.000 | Sunday | 6 | 0 | 6 | 2023-10-02 | 2023-10-15 |
2023-10-09 13:45:00.000 | Monday | 7 | 0 | 7 | 2023-10-02 | 2023-10-15 |
2023-10-10 13:45:00.000 | Tuesday | 8 | 0 | 8 | 2023-10-02 | 2023-10-15 |
2023-10-11 13:45:00.000 | Wednesday | 9 | 0 | 9 | 2023-10-02 | 2023-10-15 |
2023-10-12 13:45:00.000 | Thursday | 10 | 0 | 10 | 2023-10-02 | 2023-10-15 |
2023-10-13 13:45:00.000 | Friday | 11 | 0 | 11 | 2023-10-02 | 2023-10-15 |
2023-10-14 13:45:00.000 | Saturday | 12 | 0 | 12 | 2023-10-02 | 2023-10-15 |
2023-10-15 13:45:00.000 | Sunday | 13 | 0 | 13 | 2023-10-02 | 2023-10-15 |
2023-10-16 13:45:00.000 | Monday | 14 | 1 | 0 | 2023-10-16 | 2023-10-29 |
2023-10-17 13:45:00.000 | Tuesday | 15 | 1 | 1 | 2023-10-16 | 2023-10-29 |
2023-10-18 13:45:00.000 | Wednesday | 16 | 1 | 2 | 2023-10-16 | 2023-10-29 |
2023-10-19 13:45:00.000 | Thursday | 17 | 1 | 3 | 2023-10-16 | 2023-10-29 |
2023-10-20 13:45:00.000 | Friday | 18 | 1 | 4 | 2023-10-16 | 2023-10-29 |
2023-10-21 13:45:00.000 | Saturday | 19 | 1 | 5 | 2023-10-16 | 2023-10-29 |
2023-10-22 13:45:00.000 | Sunday | 20 | 1 | 6 | 2023-10-16 | 2023-10-29 |
2023-10-23 13:45:00.000 | Monday | 21 | 1 | 7 | 2023-10-16 | 2023-10-29 |
2023-10-24 13:45:00.000 | Tuesday | 22 | 1 | 8 | 2023-10-16 | 2023-10-29 |
2023-10-25 13:45:00.000 | Wednesday | 23 | 1 | 9 | 2023-10-16 | 2023-10-29 |
2023-10-26 13:45:00.000 | Thursday | 24 | 1 | 10 | 2023-10-16 | 2023-10-29 |
2023-10-27 13:45:00.000 | Friday | 25 | 1 | 11 | 2023-10-16 | 2023-10-29 |
2023-10-28 13:45:00.000 | Saturday | 26 | 1 | 12 | 2023-10-16 | 2023-10-29 |
2023-10-29 13:45:00.000 | Sunday | 27 | 1 | 13 | 2023-10-16 | 2023-10-29 |
2023-10-30 13:45:00.000 | Monday | 28 | 2 | 0 | 2023-10-30 | 2023-11-12 |
2023-10-31 13:45:00.000 | Tuesday | 29 | 2 | 1 | 2023-10-30 | 2023-11-12 |