| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|mysql query with date search|
| 7:47 pm on Jan 6, 2011 (gmt 0)|
I have a table which has dates for events.
the mysql column type is datetime
Now I have a calendar which returns date only (not time)
and I have full date and time both in mysql records.
So I want to run the query so it searches for all the events in that specific date?
thanks in advance.
| 8:13 pm on Jan 6, 2011 (gmt 0)|
Optimized way (if you have millions of records):
where event_date > "$date 00:00:00" and event_date <= "$date 23:59:59"
| 8:25 pm on Jan 6, 2011 (gmt 0)|
thanks very much for helping. Yes, I already tried with DATE() and it worked perfectly fine.
Thanks again for your help.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved