Mysql between

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 between

SELECT 
   orderNumber,
   requiredDate,
   status
FROM 
   orders
WHERE 
   requireddate BETWEEN 
     CAST('2003-01-01' AS DATE) AND 
     CAST('2003-01-31' AS DATE);
Code language: SQL (Structured Query Language) (sql)

Source: mysqltutorial.org

Similar codes

0 vote198 views1 answer
User defined variables in sql
SQL
17 votes258 views2 answers
How to assign date field for table in mysql
SQL
3 votes200 views1 answer
Increment integer in table sql
SQL
0 vote239 views1 answer
Sql from null to not null
SQL
0 vote197 views1 answer
Ansi sql count duplicate rows
SQL
1 vote193 views2 answers
Laravel get sql query eloquent with parameters
SQL
9 votes181 views3 answers
Show table columns mysql command line
SQL
0 vote263 views1 answer
Generate random & unique mysql string
SQL
0 vote321 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote213 views1 answer
Sql server isnull function nor working count
SQL