SELECT
  MIN(TD_TIME_FORMAT(time,'yyyy-MM-dd','JST')) AS min_d,
  MAX(TD_TIME_FORMAT(time,'yyyy-MM-dd','JST')) AS max_d
FROM access_log
WHERE /* 2017年1月のレコードのみを抽出 */
    '2017-01-01' <= TD_TIME_FORMAT(time,'yyyy-MM-dd','JST')
AND TD_TIME_FORMAT(time,'yyyy-MM-dd','JST') < '2017-02-01'