如何修复1970-01-01返回的日期？

Question

I want to search result between two date of one column and I convert date into y-m-d formate but I get response 1970-01-01, what can I do?

$dToDate = date("Y-m-d", strtotime($aData['to_date']))." 00:00:01";

    $dFromDate = date("Y-m-d", strtotime($aData['from_date']))." 23:59:59";


    $sAndWhere  = "1 = 1";
    $sAndWhere .= " AND d.created_at between '".$dToDate.' AND '.$dFromDate."'";
    $sAndWhere .= " AND u.mood =".$sMood;

    $sAndWhere .= " AND d.activated = 1 AND d.deleted=0";
    $sSql = "SELECT 
                *
            FROM 
                diaries d
            LEFT JOIN 
                users u 
            ON 
              d.id_user = u.id_user
            WHERE ".$sAndWhere;

Answer 1

$dToDate = $dFromDate = "";
if(strtotime($aData['to_date']) > 0)
{
    $dToDate = date("Y-m-d", strtotime($aData['to_date']))." 00:00:01";
}

if(strtotime($aData['from_date']) > 0)
{
    $dFromDate = date("Y-m-d", strtotime($aData['from_date']))." 23:59:59";
}

$sAndWhere  = "1 = 1";
if(($dToDate != "")  && ($dFromDate!=""))
{
    $sAndWhere .= " AND d.created_at between '".$dToDate."' AND '".$dFromDate."'";
}
else if($dToDate != "")
{
    $sAndWhere .= " AND d.created_at = '".$dToDate."'";
}
else if($dFromDate != "")
{
    $sAndWhere .= " AND d.created_at = '".$dFromDate."'";
}
$sAndWhere .= " AND u.mood =".$sMood;

$sAndWhere .= " AND d.activated = 1 AND d.deleted=0";
$sSql = "SELECT 
            *
        FROM 
            diaries d
        LEFT JOIN 
            users u 
        ON 
          d.id_user = u.id_user
        WHERE ".$sAndWhere;

use this code