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 vote302 views3 answers
Average salary in sql
SQL
0 vote379 views1 answer
Compress sql file database ubuntu
SQL
0 vote312 views1 answer
Query params sql insert python f string
SQL
0 vote327 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote307 views1 answer
Ksql quickstart docker
SQL
1 vote323 views1 answer
Psql connect
SQL
0 vote285 views1 answer
Oracle index hint multiple tables example
SQL
0 vote325 views1 answer
Call object contructor and call methods of object
SQL
1 vote317 views1 answer
Size of all tables in a schema oracle
SQL
1 vote296 views1 answer
How to get alternate records from a table in sql
SQL