[pmwiki-users] SelectQuery question
Dave Brockman
daveb at oz.net
Wed Oct 15 20:21:38 CDT 2008
Ben Stallings wrote:
> Dave Brockman wrote,
> > MONTH() and DAYOFMONTH() don't work for me. Could it be the version of
> > MySQL that I have? I know nothing, of course.
>
> No, I was mistaken about those functions defaulting to the current time.
> Turns out it's only NOW() that defaults to the current time. So you
> would have to write it as MONTH(NOW()) and DAYOFMONTH(NOW()) -- not so
> easy as I had thought.
>
> Sorry for the delay in getting back to you -- I'm glad you found a
> solution that works in the meantime! --Ben
Thanks! SelectQuery has been a joy. I've learned a lot about MySQL,
something I've alays avoided. :-)
More information about the pmwiki-users
mailing list