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 vote208 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
17 votes220 views3 answers
Postgresql version command
SQL
0 vote224 views1 answer
Mysql set variable to today's date
SQL
10 votes238 views2 answers
Tsql merge example
SQL
9 votes217 views6 answers
Sql add column with default value
SQL
0 vote216 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote242 views2 answers
Postgresql check privileges on schema
SQL
1 vote207 views2 answers
Postgresql list columns
SQL
4 votes217 views2 answers
Sql table
SQL
1 vote247 views1 answer
STOP message of how many rows affected sql
SQL