How to select date from datetime column?

by

You can use MySQL’s DATE() function:

WHERE DATE(datetime) = '2009-10-20'

You could also try this:

WHERE datetime LIKE '2009-10-20%'

See this answer for info on the performance implications of using LIKE.

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. mysql: get record count between two date-time
  5. How to cast DATETIME as a DATE in mysql?
  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. Select mysql query between date?
  17. Datetime equal or greater than today in MySQL
  18. Group mysql query by 15 min intervals
  19. How to convert time to the time zone of the iPhone device?
  20. Select data between a date/time range
  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