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 votes143 views1 answer
Mysql copy table with new name
SQL
2 votes152 views2 answers
Sql strip non alphanumeric characters
SQL
19 votes142 views2 answers
Mysql add column after another
SQL
0 vote140 views1 answer
Select from column mysql
SQL
0 vote161 views1 answer
Sql statement show all emails with dome
SQL
9 votes158 views1 answer
Identity insert on sql server
SQL
6 votes150 views5 answers
Sql add months to date
SQL
0 vote99 views1 answer
'0000-00-00' for column '
SQL
12 votes139 views2 answers
Delete all nodes neo4j
SQL
4 votes144 views1 answer
Sql delete where in select
SQL