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

1 vote280 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote261 views1 answer
Oracle get running queries
SQL
0 vote273 views1 answer
List column names of multiple tables psql
SQL
0 vote272 views1 answer
Inserted row count tsql
SQL
0 vote269 views1 answer
Partitioning in oracle-base
SQL
2 votes327 views1 answer
Remove foreign key constraints in postgres
SQL
3 votes252 views1 answer
Pl sql check if variable is empty
SQL
2 votes269 views2 answers
How to view created temporary tables in mysql
SQL
1 vote259 views1 answer
Oracle first row
SQL
1 vote298 views1 answer
Sql set auto increment back to 0
SQL