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

3 votes301 views5 answers
No module named 'MySQLdb'
SQL
0 vote264 views1 answer
Dump multiple tables mysql
SQL
0 vote255 views2 answers
Mysql disable foreign key checks
SQL
4 votes244 views2 answers
Oracle set date format
SQL
0 vote285 views1 answer
Migration graphql
SQL
4 votes278 views2 answers
Installing sql on ubuntu
SQL
20 votes252 views2 answers
Mysql bigint max value
SQL
0 vote256 views1 answer
Postgres full text search example
SQL
0 vote251 views1 answer
Xampp mysql version
SQL
0 vote277 views1 answer
Mariadb cast null to 0
SQL