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

4 votes138 views1 answer
Oracle nls_date_format
SQL
-1 vote129 views1 answer
Window functions in sql
SQL
-1 vote143 views1 answer
How to Activate the database
SQL
1 vote121 views1 answer
What is intersect
SQL
0 vote138 views1 answer
Mysql delete from where like
SQL
0 vote122 views1 answer
Date datatype in livesql
SQL
0 vote131 views1 answer
Add super privilege mysql
SQL
13 votes146 views2 answers
Sqlite rename table
SQL
0 vote132 views1 answer
How to login to mysql in homestead
SQL
2 votes120 views2 answers
Mysql user access to database
SQL