[DB] MySQL 두 날짜 차이 계산 함수(DATEDIFF() / TIMESTAMPDIFF())

■ MySQL 두 날짜 차이 계산 함수

1. DATEDIFF(날짜1, 날짜2)

※ 날짜를 인자 (날짜1 - 날짜2) 로 계산한 값을 DAY수를 반환한다.

SELECT DATEDIFF('2020-05-25 09:50:41.0', '2020-05-01 09:50:41.0') FROM DUAL;

/*
※ 출력 결과
24
*/

2. TIMESTAMPDIFF(단위, 날짜1, 날짜2)

단위

• SECOND : 초
• MINUTE : 분
• HOUR :시
• DAY : 일
• WEEK : 주
• MONTH : 월
• QUARTER : 분기
• YEAR : 연

※ 단위 인자 기준으로 (날짜2 - 날짜1) 로 계산한 값을 반환 

1) SELECT TIMESTAMPDIFF(SECOND,'2020-05-01 09:50:41.0', '2020-05-25 09:50:41.0') FROM DUAL;
: 2073600

2) SELECT TIMESTAMPDIFF(MINUTE,'2020-05-01 09:50:41.0', '2020-05-25 09:50:41.0') FROM DUAL;
: 34560

3) SELECT TIMESTAMPDIFF(HOUR,'2020-05-01 09:50:41.0', '2020-05-25 09:50:41.0') FROM DUAL;
: 576

4) SELECT TIMESTAMPDIFF(DAY,'2020-05-01 09:50:41.0', '2020-05-25 09:50:41.0') FROM DUAL;
: 24

5) SELECT TIMESTAMPDIFF(WEEK,'2020-05-01 09:50:41.0', '2021-05-25 09:50:41.0') FROM DUAL;
: 55

6) SELECT TIMESTAMPDIFF(MONTH,'2020-05-01 09:50:41.0', '2020-08-25 09:50:41.0') FROM DUAL;
: 3

7) SELECT TIMESTAMPDIFF(QUARTER,'2020-05-01 09:50:41.0', '2021-05-25 09:50:41.0') FROM DUAL;
: 4

8) SELECT TIMESTAMPDIFF(YEAR,'2020-05-01 09:50:41.0', '2022-05-25 09:50:41.0') FROM DUAL;
: 2