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 vote183 views3 answers
Sql select only time from datetime
SQL
5 votes189 views4 answers
Select random rows sql
SQL
0 vote191 views1 answer
Groupby sort sql hive
SQL
0 vote235 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote204 views2 answers
Sql stored procedure for access frontend
SQL
1 vote218 views1 answer
OSError: mysql_config not found
SQL
1 vote187 views2 answers
Datetrunc hour snowflake
SQL
2 votes201 views1 answer
Mysql select default if null
SQL
1 vote187 views1 answer
Sqlalchemy order_by
SQL
0 vote218 views1 answer
Mysql concatenate select results
SQL