doukezi4576 2016-08-01 14:48
浏览 28

'date'列上的WHERE子句

I've got table with column of type date. In my script, I generate date array as follows :

$date2 = date('Y-d-m', strtotime($date2));
for ($i = 0; $i <= 7; $i++)
{
    $date1 = str_replace('-', '/', $date2);
    $tomorrow = date('Y-d-m',strtotime($date1 . "+".$i." days"));

    echo 'counted date : '.$tomorrow.PHP_EOL ;
    array_push($dates, $tomorrow);
}

And got the following output :

counted date : 2016-01-08
counted date : 2016-02-08
counted date : 2016-03-08
counted date : 2016-04-08
counted date : 2016-05-08
counted date : 2016-06-08
counted date : 2016-07-08
counted date : 2016-08-08

I also got Phalcon expression :

$status1 = $app
    ->modelsManager
    ->executeQuery("
        SELECT * 
          FROM MastersFullTime 
         WHERE MastersFullTime.date = :date:
           AND MastersFullTime.master_id = :master_id:"
        ,
        array(
            'date' => $date , 
            'master_id' => $master_id
        )
    );

But WHERE MastersFullTime.date = :date: not working. How can I compare date objects? Thanks in advance!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 划分vlan后不通了
    • ¥15 GDI处理通道视频时总是带有白色锯齿
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)
    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大