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 vote191 views3 answers
Reset sql primary key
SQL
0 vote211 views1 answer
Sqlcmd no headers
SQL
0 vote201 views1 answer
Except in sql alchemy
SQL
1 vote184 views1 answer
Oracle update with sequence
SQL
0 vote189 views1 answer
Mysql date format unix timestamp
SQL
2 votes207 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote179 views2 answers
Show slave status mysql
SQL
1 vote244 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
2 votes223 views6 answers
In operator in sql
SQL
14 votes196 views2 answers
Oracle export trigger ddl
SQL