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

5 votes127 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote77 views1 answer
Django how to get query result count
SQL
1 vote116 views2 answers
Foreign key set 0
SQL
0 vote115 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote112 views1 answer
Update and replace mysql
SQL
1 vote120 views1 answer
Sql select whole row max column
SQL
3 votes115 views1 answer
Uppercase and lowercase in sql
SQL
8 votes144 views2 answers
Oracle undo usage
SQL
0 vote124 views1 answer
Foreign key multiple columns
SQL
0 vote114 views1 answer
Mysql where don't have string
SQL