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 vote148 views1 answer
<script>alert
SQL
0 vote147 views1 answer
Mysql case when null
SQL
0 vote174 views1 answer
Delete a record from a table sqlite3
SQL
1 vote157 views3 answers
How to get date in sql
SQL
4 votes185 views2 answers
Installing sql on ubuntu
SQL
18 votes157 views6 answers
Create table mysql
SQL
0 vote323 views1 answer
The package java.sql is not accessible
SQL
0 vote163 views1 answer
Hoq to import database source
SQL
4 votes156 views2 answers
Oracle last day of month
SQL
3 votes158 views2 answers
Sql random integer
SQL