SELECT
  TD_TIME_FORMAT(time,'yyyy-MM-01','JST') AS m,
  TD_TIME_FORMAT(time,'yyyy-MM-dd','JST') AS d,
  TD_TIME_FORMAT(time,'yyyy-MM-dd HH:00:00','JST') AS t,
  TD_TIME_FORMAT(time,'yyyy-MM-dd HH:mm:ss','JST') AS s
FROM access_log
WHERE TD_TIME_RANGE(time,'2017-01-15','2017-01-16','JST')
ORDER BY s DESC
LIMIT 1