[geeklog-devel] FW: Events Block behavior for today's events
Joe Mucchiello
joe at ThrowingDice.com
Sun Apr 13 11:41:42 EDT 2008
At 11:31 AM 4/13/2008, Dirk Haun wrote:
>Michael Jervis wrote:
>
> >I looked into it and it works as expected in current CVS.
>
>Hmm. I created an event for today, 2 hours in the future. It does not show up.
>
> SELECT * FROM gl_events WHERE dateend >= NOW();
NOW() is APR 13, 2008, 11:40:34 AM EST
>does not return the event, whereas
>
> SELECT * FROM gl_events WHERE dateend >= CURDATE();
CURDATE() is APR 13, 2008
>does.
>
>So that change does seem to make sense. Doesn't exactly match my idea of
>NOW(), but there you go ...
NOW() and CURDATE() do different things.
Event "times" in the databse as stored in two pairs of fields using
separate date and time types. If the date fields were timestamps,
NOW() would work as you expect.
Issues like this exist throughout the calendar plugin.
----
Joe Mucchiello
Throwing Dice Games
http://www.throwingdice.com
More information about the geeklog-devel
mailing list