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 vote346 views1 answer
Json_remove mysql
SQL
0 vote353 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote367 views1 answer
SQL date part only of datetime
SQL
3 votes362 views2 answers
Get current year sql
SQL
0 vote347 views3 answers
Get count of null in column sql
SQL
0 vote429 views1 answer
ALV GRID events
SQL
0 vote328 views1 answer
Mysql create table columns with spaces
SQL
0 vote366 views1 answer
Oracle temporary table
SQL
2 votes356 views3 answers
Oracle show column of table
SQL
2 votes372 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL