Results 1 to 2 of 2
Thread: How to query by date?
May 18, 2011, 20:34 #1
- Join Date
- Jul 2008
- 0 Post(s)
- 0 Thread(s)
How to query by date?
I want to find if a record in the database has overlapping date range as compared to a date range I have on hand.
If the database has a record with a startDateTime of 2011-05-19 10:00:00 and endDateTime of 2011-05-19 11:00:00.
If I have a date range of startDateTime of 2011-05-19 09:30:00 and endDateTime of 2011-05-19 10:30:00.
or my date range is startDateTIme 2011-05-19 10:30:00 and endDateTime of 2011-05-19 11:30:00.
How can I search the database in such a way that I do not get any records if the date/time do not overlap with the date/time I have on hand.
May 19, 2011, 01:16 #2Code:
WHERE table.startDateTime < '$endDateTime' AND table.endDateTime > '$startDateTime'Guido - Community Team Leader
The Votes Are In: The Winners of the 2013 Community Awards are...
Blog - Free Flash Slideshow Widget