| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe and Support 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.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved