Answers for "mysql query select date range"

SQL
1

mysql between date range

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;
Posted by: Guest on August-27-2020
0

mysql date range

select * from users 
where signup_date between '2020-05-01' and '2020-12-10 23:59:59';
// Important with the times, 
// otherwize you will not get all records from end date.
// Event if you only have date and no times in signup_date column
Posted by: Guest on December-03-2020
0

mysql select date from datetime

WHERE DATE(datetime) = '2009-10-20'
Posted by: Guest on April-29-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language