> >I need a WEEKOFMONTH function for a calendar query. Does
> anyone have such a function already?
>
> What are the semantics?
What I need is the "first Monday of each month" type of function.
"WHERE
DATE_FORMAT(".$this->objE->_table.".cal_datetime, '%Y-%m-%d')
<= DATE_FORMAT('$dt', '%Y-%m-%d
At 20:27 -0500 1/5/04, Ken Kyler wrote:
I need a WEEKOFMONTH function for a calendar query. Does anyone have such a
function already?
What are the semantics?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://w