Advertisement
TDCustmerSupportJP

Untitled

Aug 9th, 2017
22,263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. SELECT TD_TIME_FORMAT(time,'yyyy-MM-dd HH:mm:ss','JST') AS d, td_title, td_url
  2. FROM access_log
  3. /* 2017年1月1日0時〜1時のレコードのみを抽出 */
  4. WHERE TD_TIME_RANGE(time,'2017-01-01 00:00:00','2017-01-01 01:00:00','JST')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement