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

2 votes142 views2 answers
Mysql alter column default
SQL
0 vote129 views1 answer
With_for_update sqlalchemy
SQL
1 vote137 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
3 votes85 views4 answers
Show columns from table
SQL
1 vote124 views1 answer
Oracle avg
SQL
1 vote125 views1 answer
Login to database mysql terminal
SQL
1 vote123 views1 answer
Group_concat max length mysql
SQL
9 votes136 views1 answer
Identity insert on sql server
SQL
1 vote141 views1 answer
Import mysql dump database command line linux
SQL
9 votes131 views2 answers
Oracle all tables in schema
SQL