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 vote100 views1 answer
Update using case in mysql
SQL
0 vote104 views1 answer
Restart sql server command line linux
SQL
1 vote106 views2 answers
String to date postgres
SQL
4 votes119 views1 answer
W3schools create table
SQL
0 vote109 views1 answer
Mysql default uuid
SQL
3 votes108 views1 answer
Ms sql skip take
SQL
1 vote113 views1 answer
Name of today sql
SQL
103 votes290 views2 answers
Sql server LIKE '%%'
SQL
0 vote61 views1 answer
Psql not found windows
SQL
2 votes97 views1 answer
Codeigniter print last sql query
SQL