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

10 votes228 views2 answers
Sql rtrim
SQL
2 votes235 views1 answer
Oracle to_char number format percentage
SQL
-2 votes222 views1 answer
Modify column name in tsql
SQL
0 vote226 views1 answer
Sqlite closes value
SQL
0 vote228 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
5 votes237 views5 answers
Sqlite install python
SQL
-1 vote220 views1 answer
How to check table exists or not in postgresql
SQL
3 votes236 views2 answers
Postgres show table schema
SQL
13 votes261 views3 answers
Mysqldump structure only
SQL
1 vote227 views1 answer
Oracle create_program
SQL