mysql 시간차 계산, 날짜계산, 시간 계산

select id

       ,TIMESTAMPDIFF(SECOND, created_time, end_time) as a1

       ,TIMESTAMPDIFF(MINUTE, created_time, end_time) as a2

       ,TIMESTAMPDIFF(HOUR, created_time, end_time) as a3

       ,TIMESTAMPDIFF(DAY, created_time, end_time) as a4

       ,TIMESTAMPDIFF(WEEK, created_time, end_time) as a5

       ,TIMESTAMPDIFF(MONTH, created_time, end_time) as a6

       ,TIMESTAMPDIFF(QUARTER, created_time, end_time) as a7

       ,TIMESTAMPDIFF(YEAR, created_time, end_time) as a8

  from sample_table;

출처: https://118k.tistory.com/422 [개발자로 살아남기]