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 vote198 views1 answer
Sql: extract day text from datetime value
SQL
4 votes184 views2 answers
Oracle drop job
SQL
0 vote183 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote172 views1 answer
How to see all table partition in oracle
SQL
1 vote187 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote199 views2 answers
Mysql show foreign keys
SQL
0 vote182 views2 answers
Timing sql queries
SQL
9 votes185 views4 answers
Oracle get table column names
SQL
14 votes181 views2 answers
Oracle export trigger ddl
SQL
0 vote169 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL