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 vote208 views1 answer
How to run parallel queries in sql server with entity framework
SQL
2 votes249 views3 answers
Mysql cheat sheet
SQL
0 vote249 views1 answer
Many rows to 1 string mysql
SQL
0 vote185 views2 answers
Postgresql change user role grant
SQL
0 vote188 views1 answer
Is not null postgresql
SQL
1 vote213 views1 answer
Lpad function in sql oracle
SQL
0 vote191 views1 answer
Price-colour
SQL
1 vote204 views1 answer
Mysql query bulk insert
SQL
50 votes302 views6 answers
Sql count duplicate rows
SQL
1 vote269 views3 answers
Date_add mysql
SQL