By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER |
|---|
| Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production |
| PL/SQL Release 11.2.0.2.0 - Production |
| CORE 11.2.0.2.0 Production |
| TNS for Linux: Version 11.2.0.2.0 - Production |
| NLSRTL Version 11.2.0.2.0 - Production |
CREATE TABLE tabel_tabel (
ID NUMBER,
DATE_LOG DATE,
DATE_LOG_TRUNC DATE,
WORKER_ID NUMBER,
ACCESS_STATUS NUMBER(1)
);
INSERT ALL
-- первый день, затуп считывания в начале дня
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (1, TO_DATE('01.09.2023 7:49:55', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('01.09.2023', 'DD.MM.YYYY'), 123, 0)
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (2, TO_DATE('01.09.2023 7:50:00', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('01.09.2023', 'DD.MM.YYYY'), 123, 0)
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (3, TO_DATE('01.09.2023 17:01:00', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('01.09.2023', 'DD.MM.YYYY'), 123, 1)
-- второй день, затуп считывания в конце дня
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (4, TO_DATE('02.09.2023 7:55:00', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('02.09.2023', 'DD.MM.YYYY'), 123, 0)
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (5, TO_DATE('02.09.2023 17:00:30', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('02.09.2023', 'DD.MM.YYYY'), 123, 1)
INTO tabel_tabel (ID, DATE_LOG, DATE_LOG_TRUNC,WORKER_ID,ACCESS_STATUS) VALUES (6, TO_DATE('02.09.2023 17:01:00', 'DD.MM.YYYY HH24:MI:SS'), TO_DATE('02.09.2023', 'DD.MM.YYYY'), 123, 1)
SELECT * FROM dual;
6 rows affected
select t.id,
TO_CHAR(t.DATE_LOG, 'DD.MM.YYYY HH24:MI:SS') as date_log,
t.date_log_trunc,
t.worker_id,
t.access_status
from tabel_tabel t
where t.date_log_trunc >= TO_DATE('01.09.2023', 'DD.MM.YYYY')
AND t.date_log_trunc <= SYSDATE
AND t.worker_id = 123
| ID | DATE_LOG | DATE_LOG_TRUNC | WORKER_ID | ACCESS_STATUS |
|---|---|---|---|---|
| 1 | 01.09.2023 07:49:55 | 01-SEP-23 | 123 | 0 |
| 2 | 01.09.2023 07:50:00 | 01-SEP-23 | 123 | 0 |
| 3 | 01.09.2023 17:01:00 | 01-SEP-23 | 123 | 1 |
| 4 | 02.09.2023 07:55:00 | 02-SEP-23 | 123 | 0 |
| 5 | 02.09.2023 17:00:30 | 02-SEP-23 | 123 | 1 |
| 6 | 02.09.2023 17:01:00 | 02-SEP-23 | 123 | 1 |