Hey guys,
I have been trying to figure out how to return a set of results based on 2 dates which are store in my table.
I have a start_date and an end_date.
I want to grab all records which have a start_date less than now and an end_date greater than now. If end_date is less than now I want to exclude the records from the result set
I have already taken the required procedures to ensure the end_date cannot be less than start_date.
Thanks in advance
Query with dates
Moderator: General Moderators
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
Re: Query with dates
Code: Select all
SELECT
*
FROM
`table`
WHERE
`start_date` < NOW()
AND
`end_date` > NOW()