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

1 vote310 views2 answers
Mysql order by date asc null last
SQL
0 vote337 views1 answer
Oracle webcenter content search enginer
SQL
0 vote336 views1 answer
Delete duplicate rows
SQL
0 vote292 views1 answer
Mysql create table columns with spaces
SQL
1 vote355 views2 answers
Mysql extract number from string
SQL
11 votes331 views1 answer
Sql query to find duplicates in column
SQL
0 vote293 views1 answer
Grant owner postgresql
SQL
0 vote344 views1 answer
Limit in access query
SQL
1 vote320 views2 answers
Check if word is in column sql
SQL
3 votes353 views1 answer
Select count from table mysql
SQL