How to cast DATETIME as a DATE in mysql?

by

Use DATE() function:

select * from follow_queue group by DATE(follow_date)

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. How to select date from datetime column?
  5. mysql: get record count between two date-time
  6. MySQL – select data from database between two dates
  7. How to compare timestamp dates with date-only parameter in MySQL?
  8. Working with INTERVAL and CURDATE in MySQL
  9. Should I use the datetime or timestamp data type in MySQL?
  10. Get a list of dates between two dates
  11. How do you set a default value for a MySQL Datetime column?
  12. How to populate a table with a range of dates?
  13. How to group by week in MySQL?
  14. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  15. How to store a datetime in MySQL with timezone info
  16. Datetime equal or greater than today in MySQL
  17. How do I select between the 1st day of the current month and current day in MySQL?
  18. Group mysql query by 15 min intervals
  19. How to convert time to the time zone of the iPhone device?
  20. MySQL compare DATE string with string from DATETIME field
  21. How to get first day of every corresponding month in mysql?
  22. How to convert ISO8601 to Date format in php
  23. Compare only day and month with date field in mysql
  24. How to select only date from a DATETIME field in MySQL?
  25. Select all months within given date span, including the ones with 0 values
  26. Insert/ Update random date in MySQL
  27. how to partition a table by datetime column?
  28. Get total hours worked in a day mysql
  29. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  30. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?

Leave a Comment