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

0 vote338 views1 answer
Mysql select last 15 minutes
SQL
0 vote324 views1 answer
Get duplicate entry sql
SQL
8 votes364 views2 answers
Alert table name mysql
SQL
0 vote340 views1 answer
Sql delete row from table where id
SQL
0 vote355 views3 answers
Magento 2 order delete from db
SQL
1 vote326 views1 answer
MySQL AND Operator
SQL
5 votes366 views3 answers
Show indexes mysql
SQL
0 vote337 views3 answers
Between keyword sql
SQL
2 votes339 views2 answers
How to view created temporary tables in mysql
SQL
0 vote356 views1 answer
Selecting from a view SQL
SQL