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

5 votes266 views6 answers
Sql add days to date
SQL
0 vote329 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
8 votes314 views4 answers
Reset SQL auto increment
SQL
0 vote291 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote295 views4 answers
Sql server date format yyyy-mm-dd
SQL
18 votes271 views2 answers
Sql inner join
SQL
2 votes287 views1 answer
Set column to not null mysql
SQL
0 vote231 views1 answer
Mysql select top 2
SQL
0 vote312 views1 answer
Make parameters nullable in sql server
SQL
0 vote312 views1 answer
Hour and minute between two datatime sql
SQL