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 vote293 views1 answer
Mariadb create index if not exists
SQL
0 vote285 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes264 views1 answer
Create table with primary key
SQL
24 votes314 views6 answers
Sql change table name
SQL
0 vote299 views1 answer
Having all mysql
SQL
0 vote289 views1 answer
Wordpress database query change url
SQL
0 vote286 views2 answers
Oracle ora-00054 how to unlock
SQL
2 votes269 views1 answer
Brew start postgres manual
SQL
1 vote273 views1 answer
Rermove categories woocommerce sql
SQL
24 votes301 views4 answers
Postgres delete database
SQL