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 vote177 views1 answer
How to export only procedures mysql
SQL
1 vote172 views2 answers
List tables sqlalchemy
SQL
0 vote175 views1 answer
Connecting mySQL to STS
SQL
1 vote168 views1 answer
Count of tables in database mysql
SQL
0 vote167 views1 answer
Run postgresql dump to csv
SQL
13 votes163 views2 answers
Display users in mysql
SQL
2 votes161 views1 answer
Convert series number to date in sql
SQL
0 vote162 views2 answers
Sql last updated
SQL
4 votes177 views2 answers
Mysql show indexes on table
SQL
16 votes175 views4 answers
Find duplicates mysql
SQL