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 vote297 views1 answer
Oracle simple quote
SQL
1 vote235 views1 answer
Postgresql escape single quote
SQL
-1 vote245 views4 answers
Restart mysql server ubuntu
SQL
0 vote289 views1 answer
Postgres rename database
SQL
12 votes226 views2 answers
Delete all data in neo4j
SQL
11 votes223 views1 answer
How to get ddl for materialized view
SQL
0 vote236 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote226 views1 answer
Nueva tabla mysql
SQL
0 vote272 views1 answer
For select oracle
SQL
0 vote223 views1 answer
Sql query to check if column contains alphabets
SQL