Mysql date between two dates

-- 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';

Mysql date between two dates

ex1:
SELECT * FROM `objects` 
WHERE  (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

ex2:
WHERE 
   requireddate BETWEEN 
     CAST('2003-01-01' AS DATE) AND 
     CAST('2003-01-31' AS DATE);

Source: stackoverflow.com

Similar codes

34 votes122 views5 answers
Oracle alter table add column
SQL
0 vote129 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote140 views1 answer
Mysql check if lowercase
SQL
0 vote147 views1 answer
Executescalar in sql server
SQL
0 vote125 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
2 votes149 views3 answers
Sql interview query questions
SQL
1 vote156 views1 answer
How not to sort by average rating
SQL
1 vote133 views3 answers
Mysql parse int
SQL
1 vote127 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote153 views1 answer
Select all same column value in sql
SQL