mysql date between two dates

user90898

Code: SQL

2021-02-02 17:30:59

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

Joeya

Code: SQL

2021-02-02 17:29:33

SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd

user4140

Code: SQL

2021-02-02 17:32:06

##syntax: FLOOR(DATEDIFF(DATE(column_end_date), DATE(column_ini_date))/7)

Select FLOOR(DATEDIFF(DATE(20090215), DATE(20090101))/7);

Abhilodha

Code: SQL

2021-02-19 17:30:40

select * from users 
where signup_date between '2020-05-01' and '2020-12-10 23:59:59';
// Important with the times, 
// otherwize you will not get all records from end date.
// Event if you only have date and no times in signup_date column

New to Communities?

Join the community

mysql date between two dates

Tags

Related

New to Communities?