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 vote385 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
5 votes349 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote368 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote342 views1 answer
Sql server select top 2 of each group
SQL
-1 vote345 views2 answers
On update cascade
SQL
1 vote378 views1 answer
Sqlserver create table from select
SQL
1 vote384 views1 answer
Postgresql substring last
SQL
1 vote345 views1 answer
Load sql into mamp
SQL
0 vote351 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote364 views1 answer
Oracle update with sequence
SQL