Answers for "mysql select difference between two dates in days"

SQL
8

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';
Posted by: Guest on May-04-2021

Code answers related to "mysql select difference between two dates in days"

Code answers related to "SQL"

Browse Popular Code Answers by Language