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 votes767 views3 answers
Sql select last id
SQL
3 votes351 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote351 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote356 views1 answer
Oracle list datafiles
SQL
2 votes356 views2 answers
Sql lag
SQL
24 votes329 views6 answers
Rename a column in sql server
SQL
3 votes325 views1 answer
Oracle show trigger code
SQL
0 vote350 views1 answer
Prodection ready postgres database step by step
SQL
3 votes324 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote331 views1 answer
Database xml sql
SQL