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 vote195 views3 answers
Mysql delete if not in another table
SQL
0 vote235 views1 answer
Count column of tables psql
SQL
7 votes195 views2 answers
Get database size mysql
SQL
9 votes215 views4 answers
SQL Date Format
SQL
1 vote208 views1 answer
Sql set auto increment back to 0
SQL
0 vote257 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote227 views1 answer
Count number of entires by months sql
SQL
2 votes200 views1 answer
Add default sql server
SQL
0 vote196 views1 answer
Comparing with today and yesterday record in sql query
SQL
58 votes571 views4 answers
Mysql drop column
SQL