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

WEEKOFMONTH

2004-01-05 Thread Ken Kyler
I need a WEEKOFMONTH function for a calendar query. Does anyone have such a function already? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]