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 vote110 views1 answer
Pl sql constraint user function
SQL
0 vote157 views1 answer
Psql create usr
SQL
20 votes114 views2 answers
Mysql bigint max value
SQL
1 vote127 views1 answer
Sql server today minus n
SQL
8 votes118 views3 answers
Connect python to mysql
SQL
1 vote111 views1 answer
Best sql course
SQL
1 vote120 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
7 votes111 views3 answers
Sql get last inserted row
SQL
0 vote140 views1 answer
Openquery update linked server
SQL
15 votes145 views4 answers
Sql update from select
SQL