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

3 votes290 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
16 votes292 views2 answers
Add column if not exists mysql
SQL
0 vote285 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote296 views1 answer
Implicit inner join table alias
SQL
1 vote280 views1 answer
Apex select list ORA-20999
SQL
3 votes310 views3 answers
Raw select laravel
SQL
5 votes282 views2 answers
Postgre insert select
SQL
2 votes276 views1 answer
Sql like variable
SQL
0 vote308 views1 answer
Postgresql find biggest table
SQL
0 vote282 views1 answer
Show table structure mysql console
SQL