By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| DT | TO_CHAR(DT,'DAY') | TO_CHAR(DT,'D') |
|---|---|---|
| 25-JUL-22 | MONDAY | 2 |
| 26-JUL-22 | TUESDAY | 3 |
| 27-JUL-22 | WEDNESDAY | 4 |
| 28-JUL-22 | THURSDAY | 5 |
| 22-JUL-22 | FRIDAY | 6 |
| 23-JUL-22 | SATURDAY | 7 |
| 24-JUL-22 | SUNDAY | 1 |
| DT | TO_CHAR(DT,'DAY') | TO_CHAR(DT,'D') |
|---|---|---|
| 25.07.22 | MONDAY | 1 |
| 26.07.22 | TUESDAY | 2 |
| 27.07.22 | WEDNESDAY | 3 |
| 28.07.22 | THURSDAY | 4 |
| 22.07.22 | FRIDAY | 5 |
| 23.07.22 | SATURDAY | 6 |
| 24.07.22 | SUNDAY | 7 |