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

0 vote305 views1 answer
Oracle job class
SQL
1 vote297 views1 answer
What is intersect
SQL
0 vote329 views1 answer
Firebase sql
SQL
20 votes312 views1 answer
Sql change column types
SQL
0 vote285 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote318 views1 answer
Sql cmd no truncate
SQL
4 votes320 views2 answers
Dbms output
SQL
1 vote304 views1 answer
Postgres set column equal to another
SQL
0 vote302 views1 answer
Partitioning in oracle-base
SQL
0 vote325 views1 answer
Mysql zerofill
SQL