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

6 votes306 views1 answer
SQL insert all columns
SQL
0 vote317 views1 answer
Mysql workbench procedure
SQL
3 votes355 views2 answers
Laravel tosql with bindings
SQL
25 votes379 views1 answer
How to update an attribute in MySQL
SQL
11 votes329 views1 answer
Sql insert multiple rows from select
SQL
0 vote351 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote346 views1 answer
Postrgres trunc
SQL
0 vote307 views1 answer
MySql count occurences more than"
SQL
0 vote332 views1 answer
T sql cursor tr
SQL
5 votes343 views2 answers
To date oracle
SQL