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 vote135 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote142 views1 answer
Min salary in sql
SQL
0 vote166 views10 answers
John the ripper mysql
SQL
0 vote130 views1 answer
How to to get current date and time in sql
SQL
6 votes164 views2 answers
Clear a table in mysql
SQL
0 vote207 views1 answer
Sql to search who modified
SQL
1 vote141 views1 answer
Sql select row with max date
SQL
2 votes139 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
2 votes134 views1 answer
Mysql query unique column
SQL
3 votes154 views2 answers
How to open postgresql in windows
SQL