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

5 votes209 views2 answers
Get columns number sql
SQL
0 vote218 views1 answer
Sql output select
SQL
0 vote191 views1 answer
Get all employees if name ends with in sql
SQL
1 vote205 views1 answer
Pgsql sum switch case
SQL
0 vote205 views1 answer
Sql waitfor
SQL
1 vote201 views1 answer
Add constraint sql
SQL
11 votes209 views1 answer
Mysql text type max length
SQL
-1 vote204 views3 answers
SQL MM/dd/yyyy format
SQL
2 votes219 views1 answer
Q operator in oracle
SQL
0 vote164 views1 answer
Sql new line output
SQL