RE: WEEKOFMONTH

2004-01-06 Thread Ken Kyler
> >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

Re: WEEKOFMONTH

2004-01-05 Thread Paul DuBois
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