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 votes126 views1 answer
Select count from table mysql
SQL
0 vote108 views1 answer
Frename oracle
SQL
103 votes194 views2 answers
Sql server LIKE '%%'
SQL
0 vote131 views2 answers
T SQl Checking Your Username
SQL
1 vote117 views1 answer
Xampp import sql file command line
SQL
5 votes127 views1 answer
Find table from column name in sql
SQL
0 vote121 views1 answer
Oracle archivemode
SQL
1 vote116 views1 answer
Sql server locks
SQL
0 vote72 views4 answers
Sql limit 1 offset 1
SQL
0 vote108 views1 answer
Oracle last character of string
SQL