$SugarQuery = new SugarQuery();
$SugarQuery->from(BeanFactory::getBean('Contacts'));
$documents = $SugarQuery->join('documents')->joinName();
$SugarQuery->select(array("$documents.dms_document_id_c","$documents.document_name","$documents.date_entered"));
$SugarQuery->where()->equals('id', $args['km']);
$SugarQuery->where()->equals("$documents.document_name", $args['document_type']);
$SugarQuery->orderByRaw("$documents.date_modified");
$results = $SugarQuery->execute();
output:-
{
"dms_document_id_c": "9765444",
"document_name": "Crop",
"date_entered": "2020-12-23 10:20:03"
}
How to get only date not time from date_entered in $results?
Like,
"date_entered": "2020-12-23 "