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

4 votes218 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote202 views1 answer
Get null value in sql
SQL
9 votes225 views3 answers
Postgres make sql dump
SQL
3 votes176 views1 answer
Select count from table mysql
SQL
0 vote167 views1 answer
Mysql identified by syntax error
SQL
0 vote190 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote161 views1 answer
Create table tablename as select * from tablename
SQL
0 vote169 views1 answer
Select password from user mysql
SQL
3 votes161 views2 answers
Mysql create database
SQL
3 votes173 views5 answers
Mysql get last inserted id
SQL