mysql timestamp 1분 이내 매치하기

between 이나 TIMEDIFF 이런걸로 될 줄 알았는데 영안되서

결국에는 +-15로 계산을 해야겠네.. 끄응

select T.temperature, T.humidity, T.created as tcreated, P.ph, P.voltage, P.created as pcreated  from (select * from dht11 where DATE(created) >= '2018-12-20' ) as T,  (select * from ph where DATE(created) >= '2018-12-20' ) as P WHERE TIME_TO_SEC(P.created) - 15 < TIME_TO_SEC(T.created) AND TIME_TO_SEC(T.created) < TIME_TO_SEC(P.created) + 15;

[링크 : https://www.w3resource.com/mysql/date-and-time-functions/mysql-time_to_sec-function.php]

[링크 : https://stackoverflow.com/questions/7636599/calculating-time-difference-between-2-dates-in-minutes]

[링크 : https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timestampdiff]