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

13 votes160 views2 answers
Oracle inner join
SQL
0 vote144 views1 answer
Mysql where in maintain order
SQL
0 vote158 views1 answer
Repeatable read trong sql server
SQL
0 vote125 views1 answer
Trim sql oracle
SQL
0 vote142 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote131 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote127 views1 answer
Sql random decimal
SQL
4 votes126 views2 answers
Postgres update single column
SQL
3 votes135 views1 answer
Créer une table sql
SQL
79 votes323 views6 answers
Grepper code
SQL