By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CALC_DATE | DAILY_HRS | RUN_SUM |
---|---|---|
31-MAY-19 | +000000000 08:00:00.000000000 | +000000000 08:00:00.000000000 |
01-JUN-19 | null | +000000000 08:00:00.000000000 |
02-JUN-19 | null | +000000000 08:00:00.000000000 |
03-JUN-19 | +000000000 01:00:00.000000000 | +000000000 09:00:00.000000000 |
CALC_DATE | ISWEEKDAY | ISWEEKDAY_BAD | DAILY_HRS | RUN_SUM |
---|---|---|---|---|
31-MAY-19 | 1 | 1 | +000000000 08:00:00.000000000 | +000000000 08:00:00.000000000 |
01-JUN-19 | null | 1 | null | +000000000 08:00:00.000000000 |
02-JUN-19 | null | null | null | +000000000 08:00:00.000000000 |
03-JUN-19 | 1 | null | +000000000 01:00:00.000000000 | +000000000 09:00:00.000000000 |