Group by date only on a Datetime column

by

Cast the datetime to a date, then GROUP BY using this syntax:

SELECT SUM(foo), DATE(mydate) FROM a_table GROUP BY DATE(a_table.mydate);

Or you can GROUP BY the alias as @orlandu63 suggested:

SELECT SUM(foo), DATE(mydate) DateOnly FROM a_table GROUP BY DateOnly;

Though I don’t think it’ll make any difference to performance, it is a little clearer.

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL number of items within “in clause”
  6. Error 1046 No database Selected, how to resolve?
  7. What’s the difference between VARCHAR and CHAR?
  8. Alter a MySQL column to be AUTO_INCREMENT
  9. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  10. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  11. single fixed table with multiple columns vs flexible abstract tables
  12. MySQL remove duplicates from big database quick
  13. mysql, iterate through column names
  14. How to delete from select in MySQL?
  15. How to delete Duplicates in MySQL table
  16. How to ORDER BY a SUM() in MySQL?
  17. mySQL Returning the top 5 of each category
  18. Selecting Random Rows in MySQL
  19. mysql – how many columns is too many?
  20. Best database field type for a URL
  21. Use A Union Or A Join – What Is Faster [closed]
  22. MySQL – how to front pad zip code with “0”?
  23. Find the number of columns in a table
  24. Mysql, reshape data from long / tall to wide
  25. MySQL: Compare differences between two tables
  26. How do I start auto increment from a specific point?
  27. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  28. MySql bulk load command line tool
  29. ALTER TABLE without locking the table?
  30. MySQL: Typecasting NULL to 0

Leave a Comment