TDCustmerSupportJP

Untitled

Aug 12th, 2017
22,246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.37 KB | None | 0 0
  1. SELECT
  2. TD_TIME_PARSE('2017','JST') AS parse1,
  3. TD_TIME_PARSE('2017-01','JST') AS parse2,
  4. TD_TIME_PARSE('2017-01-15','JST') AS parse3,
  5. TD_TIME_PARSE('2017/01/15','JST') AS parse4,
  6. TD_TIME_PARSE('2017-01-15 23:00:00','JST') AS parse5,
  7. TD_TIME_PARSE('2017/01/15 23:00:00','JST') AS parse6
  8. FROM access_log
  9. WHERE TD_TIME_RANGE(time,'2017-01-15','2017-01-16','JST')
  10. LIMIT 1
Add Comment
Please, Sign In to add comment