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

5 votes133 views1 answer
Add column table sql default value
SQL
1 vote136 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote139 views2 answers
Timing sql queries
SQL
14 votes136 views5 answers
Sql oracle limit
SQL
3 votes145 views2 answers
Search text in all sql server stored procedure
SQL
0 vote144 views1 answer
Sql select random procentage from rows
SQL
0 vote187 views1 answer
Ora 00001 error catch plsql
SQL
9 votes127 views3 answers
Show table columns mysql command line
SQL
0 vote138 views1 answer
Oracle get running queries
SQL
7 votes143 views1 answer
Query delete duplicates
SQL