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 vote200 views1 answer
Sql trying to delete database in use
SQL
0 vote226 views1 answer
How to check foreign key constraint in sql
SQL
5 votes305 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote210 views1 answer
Hotw to alter lengh character vayng postgres
SQL
4 votes196 views1 answer
Sql any
SQL
6 votes208 views1 answer
What is where clause in sql
SQL
27 votes263 views6 answers
Sql update record
SQL
6 votes279 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote210 views1 answer
Sql cmd no truncate
SQL
-2 votes210 views1 answer
Create trigger syntax
SQL