Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- TD_TIME_PARSE('2017','JST') AS parse1,
- TD_TIME_PARSE('2017-01','JST') AS parse2,
- TD_TIME_PARSE('2017-01-15','JST') AS parse3,
- TD_TIME_PARSE('2017/01/15','JST') AS parse4,
- TD_TIME_PARSE('2017-01-15 23:00:00','JST') AS parse5,
- TD_TIME_PARSE('2017/01/15 23:00:00','JST') AS parse6
- FROM access_log
- WHERE TD_TIME_RANGE(time,'2017-01-15','2017-01-16','JST')
- LIMIT 1
Add Comment
Please, Sign In to add comment