MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


create table ATT_LOG (EMP_ID varchar(6), DATE_ATT date, TIME_ATT time)
insert into ATT_LOG values ('E-0123', '2024-01-02', '08:05:56')
insert into ATT_LOG values ('E-0123', '2024-01-02', '17:02:23')
insert into ATT_LOG values ('E-0124', '2024-01-02', '21:55:56')
insert into ATT_LOG values ('E-0124', '2024-01-03', '06:02:23')
select EMP_ID
      ,date(min(timestamp(DATE_ATT, TIME_ATT))) as THE_DATE
      ,time(min(timestamp(DATE_ATT, TIME_ATT))) as IN_TIME
      ,time(max(timestamp(DATE_ATT, TIME_ATT))) as OUT_TIME
  from ATT_LOG
 group by EMP_ID


EMP_ID
THE_DATE
IN_TIME
OUT_TIME


E-0123
2024-01-02
08:05:56
17:02:23

E-0124
2024-01-02
21:55:56
06:02:23

EMP_ID	THE_DATE	IN_TIME	OUT_TIME
E-0123	2024-01-02	08:05:56	17:02:23
E-0124	2024-01-02	21:55:56	06:02:23