Select data between a date/time range

by

You need to update the date format:

select * from hockey_stats 
where game_date between '2012-03-11 00:00:00' and '2012-05-11 23:59:00' 
order by game_date desc;

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. How do you set a default value for a MySQL Datetime column?
  3. MySQL Query GROUP BY day / month / year
  4. Error in MySQL when setting default value for DATE or DATETIME
  5. How to group by week in MySQL?
  6. Difference between two dates in MySQL
  7. MySQL Query to select data from last week?
  8. MySQL convert date string to Unix timestamp
  9. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  10. Timestamp with a millisecond precision: How to save them in MySQL
  11. How to store a datetime in MySQL with timezone info
  12. How to select date from datetime column?
  13. Datetime equal or greater than today in MySQL
  14. How to convert number of week into date?
  15. Set NOW() as Default Value for datetime datatype?
  16. Group mysql query by 15 min intervals
  17. SQL Query to show nearest date?
  18. How to subtract hours from a datetime in MySQL?
  19. How to convert time to the time zone of the iPhone device?
  20. mysql: get record count between two date-time
  21. MySql difference between two timestamps in days?
  22. How to cast DATETIME as a DATE in mysql?
  23. How to get current date & time in MySQL?
  24. how to cast the hexadecimal to varchar(datetime)?
  25. How to compare timestamp dates with date-only parameter in MySQL?
  26. how to partition a table by datetime column?
  27. Get total hours worked in a day mysql
  28. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  29. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment