Does anyone have any idea how to put together an array to make the
DATE_FORMAT work?
On Apr 8, 7:21 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> I'm trying to use a findall query and use the MYSQLDATE_FORMAT
> function.
>
> The code is
>
> $criteria = array();
> $criteria['DATE_FORMAT(Sch
I'm trying to use a findall query and use the MYSQL DATE_FORMAT
function.
The code is
$criteria = array();
$criteria['DATE_FORMAT(Schedule.start,\'%w\')'] = 3;
$this->Schedule->findAll($criteria);
My code as it runs produces...
SELECT * FROM `studioschedules` AS `Schedule`WHERE
DATE_FORMAT(`S