SELECT TD_TIME_FORMAT(time,'yyyy-MM-dd','JST') AS d, td_title, td_url
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'
LIMIT 10