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

0 vote177 views1 answer
Hibernate show sql xml property
SQL
4 votes164 views1 answer
Create db table
SQL
1 vote164 views1 answer
Mysql current time
SQL
12 votes161 views3 answers
Duplicate a column in sql
SQL
1 vote210 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote171 views1 answer
Windows services sql
SQL
0 vote216 views1 answer
Mysql faster delete
SQL
12 votes163 views4 answers
Mysql ifnull
SQL
1 vote166 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
7 votes162 views3 answers
Postgresql dump and restore db
SQL