Mysql check date range

-- With implicit CAST
SELECT * FROM my_table 
	WHERE my_date BETWEEN '2021-06-01 01:12:00' AND '2021-06-30 23:59:59';
-- is EQUIVALENT to
SELECT * FROM my_table 
	WHERE my_date >= '2021-06-01 01:12:00' AND my_col <= '2021-06-30 23:59:59';

Similar codes

12 votes183 views4 answers
Mysql get date difference in hours
SQL
0 vote229 views1 answer
Arithmetic expression in sql
SQL
0 vote213 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote210 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
-2 votes196 views1 answer
Use of where in left join in mysql
SQL
0 vote215 views1 answer
How to see the query of a view in mysql
SQL
0 vote157 views1 answer
Postgres delete where id in
SQL
1 vote201 views1 answer
Tsql get beginning of year
SQL
0 vote189 views2 answers
Sql having multiple conditions
SQL
0 vote198 views2 answers
How to get last inserted id in sql server c#
SQL