codingknob codingknob - 1 month ago 7
MySQL Question

Select data between a date range

How do I select data between a date range in MySQL. My

datetime
column is in 24-hour zulu time format.

select * from hockey_stats
where game_date between '11/3/2012 00:00:00' and '11/5/2012 23:59:00'
order by game_date desc;


Returns nothing despite having data between these time periods. Do I have to force the values in the 'from' and 'to' fields to
datetime
type in the query?

Answer

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;