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 vote141 views1 answer
Mysql aspas simples
SQL
1 vote122 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote141 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes140 views4 answers
Mysql create table from select statement
SQL
1 vote109 views1 answer
How to get mysql db size
SQL
6 votes127 views5 answers
Sql add months to date
SQL
0 vote119 views4 answers
Mysql replace regex
SQL
0 vote117 views1 answer
Oracle job class
SQL
0 vote136 views1 answer
Mysql value ends with
SQL
0 vote128 views1 answer
Sql query for displaying age from oldest to youngest
SQL