Advertisement
TDCustmerSupportJP

Untitled

Aug 12th, 2017
22,257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. SELECT TD_SESSIONIZE(time, 3600, td_client_id) as session_id, time, td_client_id, td_title
  2. FROM (
  3.   SELECT time, td_client_id, td_title
  4.   FROM access_log
  5.   WHERE TD_TIME_RANGE(time,'2017-01-15','2017-01-16','JST')
  6.   ORDER BY td_client_id, time
  7. ) t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement