야간근무는 22:00 ~ 06:00 사이에 발생하면 야간근무로 처리합니다.
실제 출퇴근은 04:00 ~ 23:00 로 할경우 야간시간을 앞뒤로 처리해야되는데.어찌할지..
고수님들 도와주세요.
WITH WT_A AS
(
SELECT '0400' AS START_TIME, '2300' AS END_TIME FROM DUAL UNION ALL
SELECT '0800' AS START_TIME, '2300' AS END_TIME FROM DUAL UNION ALL
SELECT '0400' AS START_TIME, '1200' AS END_TIME FROM DUAL
)
SELECT ....
FROM WT_A
|