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 vote197 views1 answer
Postgres enumerated type
SQL
0 vote205 views1 answer
Primary key multiple colums
SQL
9 votes217 views2 answers
Sql limit to 5 results
SQL
7 votes222 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote208 views1 answer
Decalre temp table sql
SQL
7 votes210 views4 answers
Index in mysql
SQL
8 votes224 views3 answers
SQL column name
SQL
0 vote192 views1 answer
Initcap in sql
SQL
0 vote264 views1 answer
T-sql delete view if exists
SQL
0 vote197 views1 answer
Sql contains vs like
SQL