当我选择数据1周时，PHP PDO无法使用select

//Not working code

require ('../catalog/view/theme/default/template/config/dbconfig.php');
$stmt1=$DB_CON->prepare('select count(*) as t,sum(total) as total,CAST(date_added as DATE) as date_added from oc_order where date_added>DATE_SUB(NOW(),INTERVAL 1 WEEK) group by CAST(date_added as DATE) order by date_added DESC');
$stmt1->execute();
$record1=$stmt1->fetchAll(PDO::FETCH_ASSOC);
var_dump($record1);

but above query is working in phpmyadmin and it is returns data properly but it is not working in pdo in php. below code works perfectly even though it is same query

//working code->when i am selecting data for 1 Month

$stmt1=$DB_CON->prepare('select count(*) as t,sum(total) as total,CAST(date_added as DATE) as date_added from oc_order where date_added>DATE_SUB(NOW(),INTERVAL 1 MONTH) group by CAST(date_added as DATE) order by date_added DESC');
$stmt1->execute();
$record1=$stmt1->fetchAll(PDO::FETCH_ASSOC);
var_dump($record1);

is there any way to resolve this problem?