Skip to content

Instantly share code, notes, and snippets.

@edenzik

edenzik/BinningFunctionPostgres

Last active August 29, 2015 14:02
Show Gist options
  • Save edenzik/b7a55b8211027a31931a to your computer and use it in GitHub Desktop.
Save edenzik/b7a55b8211027a31931a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BinningFunctionPostgres
SELECT date_trunc('milliseconds', frame_time), SUM(frame_len)
FROM frame
GROUP BY date_trunc('milliseconds', frame_time);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment