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

1 vote141 views1 answer
Mysql return text after a final full stop
SQL
0 vote114 views3 answers
Sql select statements
SQL
8 votes123 views1 answer
Oracle all_source package body
SQL
0 vote157 views1 answer
Psql create usr
SQL
7 votes113 views1 answer
Postgres base size
SQL
12 votes110 views2 answers
Delete all data in neo4j
SQL
2 votes240 views2 answers
MySql FULL OUTER JOIN
SQL
-1 vote118 views1 answer
Export mysql table to file
SQL
1 vote111 views3 answers
Read all columns of a table sql
SQL
0 vote120 views1 answer
How to join result table in mysql
SQL