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 vote336 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote309 views1 answer
Sql server locks
SQL
0 vote325 views1 answer
Less mysql display
SQL
0 vote300 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
8 votes301 views1 answer
Insert a select statement into a table
SQL
0 vote295 views1 answer
Postgresql create table default value timestamp
SQL
1 vote312 views2 answers
Limit sqlserver
SQL
1 vote317 views1 answer
Mysql dump specific tables
SQL
0 vote331 views3 answers
Fetlife
SQL
0 vote345 views1 answer
Get primary key of table
SQL