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

0 vote213 views1 answer
Sqlite get date only
SQL
1 vote199 views1 answer
Load mysql dumb
SQL
1 vote186 views1 answer
SQL: merging multiple row data in string
SQL
4 votes228 views1 answer
Mysql query first character
SQL
1 vote142 views1 answer
Ms sql how to see active job current run time
SQL
0 vote196 views1 answer
Sql_inner_join
SQL
-1 vote183 views1 answer
How to dump .csv file into mysql
SQL
0 vote164 views1 answer
Edit a field mysql terminal
SQL
2 votes275 views1 answer
Oracle list grants on package
SQL
3 votes182 views1 answer
Create a table with an id in mysql
SQL