Skip to content

Instantly share code, notes, and snippets.

@savepong

savepong/date-only.sql

Created April 4, 2017 14:18
Show Gist options
  • Save savepong/cabbca44863ca40245a6773d85437e4c to your computer and use it in GitHub Desktop.
Save savepong/cabbca44863ca40245a6773d85437e4c to your computer and use it in GitHub Desktop.
Download ZIP
MySQL/SQL: Group by date only on a Datetime column
Raw
date-only.sql
SELECT DATE(latest_update) DateOnly FROM users GROUP BY DateOnly LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment