Advertisement
TDCustmerSupportJP

Untitled

Jul 6th, 2017
2,980
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.24 KB | None | 0 0
  1. SELECT
  2.   MIN(TD_TIME_FORMAT(time,'yyyy-MM-dd','JST')) AS min_d,
  3.   MAX(TD_TIME_FORMAT(time,'yyyy-MM-dd','JST')) AS max_d
  4. FROM access_log
  5. /* 2016年までのレコードを除外 */
  6. WHERE NOT TD_TIME_RANGE(time,'2011-01-01','2017-01-01','JST')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement