Mysql date range

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;

Source: stackoverflow.com

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

Similar codes

-1 vote286 views1 answer
Mysql how to set update or create
SQL
0 vote356 views1 answer
Hibernate with springboot mysql
SQL
1 vote340 views2 answers
Postgresql list columns
SQL
1 vote347 views1 answer
Oracle aleter trigger ora-01031
SQL
-1 vote348 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote377 views1 answer
Sql server pivot rows to columns
SQL
0 vote356 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote341 views1 answer
Postgre admin slow
SQL
0 vote357 views1 answer
Sqlite to csv statement
SQL
0 vote388 views1 answer
Time data type in mysql
SQL