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

1 vote240 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
3 votes227 views3 answers
Concatenation in sql
SQL
0 vote218 views1 answer
Mysql installer no packages found
SQL
0 vote228 views1 answer
MySQL import data from large CSV file
SQL
0 vote223 views1 answer
Delete data from database sqlite android
SQL
0 vote251 views1 answer
Yesql
SQL
0 vote229 views1 answer
Sql decode
SQL
2 votes221 views1 answer
Drop table purge
SQL
11 votes245 views2 answers
Having clause in sql
SQL
3 votes236 views1 answer
RENAME table pl sql
SQL