[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