SELECT room_name as room_name,seat_no,use_date||' '||start_time || '~' || end_time as use_time
FROM
(
SELECT substr(A.start_date,1,4) ||'.'|| substr(A.start_date,5,2)||'.'|| substr(A.start_date,7,2) as use_date,
A.room_no as room_no,
B.room_name as room_name,
A.seat_no as seat_no,
substr(A.start_time,1,2) ||':'|| substr(A.start_time,3,2) as start_time,
substr(A.end_time,1,2)||':'|| substr(A.end_time,3,2) as end_time,
substr(A.start_time,0,5) as use_time
FROM seat_room B, seat_log A
WHERE B.room_no > 0
AND A.room_no = B.room_no
AND A.user_id = TRIM('')
) A
order by use_date desc,use_time desc
모바일 도서관