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 vote271 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote271 views2 answers
Create a unqie constraint mysql
SQL
1 vote304 views1 answer
T-sql disable system versioning
SQL
6 votes281 views2 answers
Oracle
SQL
0 vote311 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
3 votes260 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
-1 vote296 views2 answers
Postgres autoincrement primary key
SQL
0 vote282 views1 answer
SQL SELECT-Klausel
SQL
0 vote237 views1 answer
How to set field to null in sql
SQL
1 vote283 views3 answers
Nth highest salary
SQL