[pmwiki-users] SelectQuery question
Ben Stallings
ben at interdependentweb.com
Tue Oct 14 18:52:54 CDT 2008
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
More information about the pmwiki-users
mailing list