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

17 votes374 views2 answers
T_sql contains
SQL
0 vote335 views1 answer
Login phpmyadmin without password
SQL
-1 vote366 views1 answer
Window functions in sql
SQL
0 vote335 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote366 views1 answer
Postgres dump sql insert
SQL
2 votes357 views1 answer
Orcale index size
SQL
5 votes337 views1 answer
How to use rank function in sql
SQL
2 votes328 views1 answer
Check isolation level in mysql
SQL
0 vote385 views1 answer
How to find date from date table in sql
SQL
2 votes336 views4 answers
Duplicate record mysql
SQL