How to compare timestamp dates with date-only parameter in MySQL?

by

You can use the DATE() function to extract the date portion of the timestamp:

SELECT * FROM table
WHERE DATE(timestamp) = '2012-05-25'

Though, if you have an index on the timestamp column, this would be faster because it could utilize an index on the timestamp column if you have one:

SELECT * FROM table
WHERE timestamp BETWEEN '2012-05-25 00:00:00' AND '2012-05-25 23:59:59'

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. How to cast DATETIME as a DATE in mysql?
  7. MySQL – select data from database between two dates
  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. Insert/ Update random date in MySQL
  26. Get total hours worked in a day mysql
  27. adding 1 day to a DATETIME format value
  28. MySQL: Insert datetime into other datetime field
  29. MySQL: Find Missing Dates Between a Date Range
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment