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

1 vote193 views1 answer
Psql datetime grather than
SQL
2 votes199 views1 answer
Sql server case sensitive search
SQL
-1 vote206 views1 answer
Default username and password for oracle 11g
SQL
2 votes245 views1 answer
Remove foreign key constraints in postgres
SQL
1 vote186 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote203 views1 answer
Oracle concat datetime
SQL
0 vote197 views1 answer
Intellij idea add mysql connector
SQL
7 votes181 views1 answer
Append column sql
SQL
1 vote214 views1 answer
Select users with same username
SQL
0 vote186 views1 answer
How to select even id in sql
SQL