Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- TD_TIME_FORMAT(time, 'yyyy-MM-dd') AS date_s,
- TD_TIME_FORMAT(time, 'HH:mm') AS time_s,
- count(*) cnt
- FROM my_table
- GROUP BY
- TD_TIME_FORMAT(time, 'yyyy-MM-dd')
- TD_TIME_FORMAT(time, 'HH:mm')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement