Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 /* 2016年までのレコードを除外 */
- NOT ( '2011-01-01' <= TD_TIME_FORMAT(time,'yyyy-MM-dd','JST') AND TD_TIME_FORMAT(time,'yyyy-MM-dd','JST') < '2017-01-01' )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement