[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