在日期cakephp 3之间

Question

当我在日期和日志之间设置一个日期时，这会增加空格。

$campaigns = TableRegistry::get('Administrator.Campaigns');
    $campaignsActual= $campaigns->find('All')
   ->where('parent_id IS NULL AND '.date("Y-m-d").' BETWEEN start AND end')

但

SELECT Campaigns.id ASCampaigns__id, Campaigns.name ASCampaigns__name, Campaigns.description ASCampaigns__description, Campaigns.start ASCampaigns__start, Campaigns.end ASCampaigns__end, Campaigns.status ASCampaigns__status, Campaigns.parent_id ASCampaigns__parent_id, Campaigns.lft ASCampaigns__lft, Campaigns.rght ASCampaigns__rght, Campaigns.created ASCampaigns__created, Campaigns.modified ASCampaigns__modified FROM campaigns Campaigns WHERE parent_id IS NULL AND 2017 - 01 - 23 BETWEEN start AND end

2017 - 01 - 23生成空格的日期如何确保这些空格不被转换？

Answer 1

问题是->where('parent_id IS NULL AND "'.date("Y-m-d").'" BETWEEN start AND end')

“.date(”Y-m-d“)”