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 vote364 views1 answer
Mysql vs sql server performance benchmark
SQL
-2 votes321 views3 answers
Oracle tablespace usage
SQL
0 vote344 views1 answer
Delete first row in sql
SQL
11 votes346 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote341 views1 answer
Postgresql on conflict pair
SQL
0 vote318 views1 answer
Sql database size
SQL
0 vote334 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote328 views1 answer
Mysql database hyphen
SQL
5 votes389 views3 answers
Sql limit offset
SQL
0 vote314 views1 answer
Implicit inner join table alias with id values
SQL