[geeklog-devel] FW: Events Block behavior for today's events

[Mark Howard]

Hi Joe -

I agree with Dirk - the use of CURDATE() provides the desired behavior.

I won't dispute the fact that many other similar issues exist.  ;^)

-m


-----Original Message-----
From: geeklog-devel-bounces at lists.geeklog.net
[mailto:geeklog-devel-bounces at lists.geeklog.net] On Behalf Of Joe Mucchiello
Sent: Sunday, April 13, 2008 11:42 AM
To: Geeklog Development
Subject: Re: [geeklog-devel] FW: Events Block behavior for today's events

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 

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://eight.pairlist.net/mailman/listinfo/geeklog-devel