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 vote318 views2 answers
Insert data into multiple tables mysql
SQL
1 vote262 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote253 views1 answer
Varchar format not case sensitive sql
SQL
27 votes255 views4 answers
Get all tables with column name sql
SQL
2 votes258 views2 answers
Sql first character
SQL
1 vote257 views1 answer
Mysql count multiple columns in one query
SQL
0 vote274 views1 answer
How to map sql column to custom names
SQL
0 vote240 views4 answers
Sql limit 1 offset 1
SQL
3 votes269 views1 answer
Laravel database Using Named Bindings
SQL
0 vote225 views1 answer
Get only first row mysql
SQL