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 vote203 views1 answer
Insert using condition postgres
SQL
0 vote153 views1 answer
Postgresql subquery
SQL
7 votes224 views1 answer
Sql pagination oracle
SQL
0 vote209 views1 answer
How to join result table in mysql
SQL
6 votes199 views2 answers
Mysql convert timestamp to date
SQL
0 vote275 views1 answer
Sintaxis SELECT sql
SQL
0 vote207 views1 answer
Mssql dockere
SQL
1 vote190 views1 answer
Oracle sql create view
SQL
1 vote260 views1 answer
Oracle grant select on schema
SQL
0 vote186 views1 answer
Check index sql server
SQL