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 vote330 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
2 votes283 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote268 views1 answer
Update from select join
SQL
0 vote274 views1 answer
Update set with join pl sql
SQL
1 vote299 views1 answer
How to change owner in postgres
SQL
0 vote340 views1 answer
Sql trim whitespace
SQL
0 vote278 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote283 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote301 views1 answer
Sql period overlap
SQL
0 vote287 views1 answer
Grouping by email domain mysql
SQL