Categories : SQL
SQL 예시 - (12) 두개의 날짜 간의 차이 (feat. TIMESTAMPDIFF, JOIN)
0. SQL 문제
CUSTOMER_INS (손님 입장)
| ID | DATETIE |
|---|---|
| A | 2024-01-01 08:00:00 |
| B | 2024-01-05 08:00:00 |
CUSTOMER_OUTS (손님 퇴장)
| ID | DATETIE |
|---|---|
| A | 2024-01-01 08:15:00 |
| B | 2024-01-05 08:10:00 |
1. 계산 진행
SELECT
ci.ID,
ci.DATETIME AS 입장시간,
co.DATETIME AS 퇴장시간,
TIMESTAMPDIFF(SECOND, ci.DATETIME, co.DATETIME) AS 초
FROM CUSTOMER_INS ci
JOIN CUSTOMER_OUTS co ON ci.ID = co.ID;
2. 실행 결과
| ID | 입장시간 | 퇴장시간 | 초 |
|---|---|---|---|
| A | 2024-01-01 08:00:00 | 2024-01-01 08:15:00 | 900 |
| B | 2024-01-05 08:00:00 | 2024-01-05 08:10:00 | 600 |