PHP ORM Where Clause - Date Only, Ignore Time

[blueprint]

How can I filter (using the EspoCRM PHP functions) a date-time field by the date only - ignoring the time part?

$list = $this->getEntityManager()->getRepository($entityType)->where([
'date(createdAt)' => date("Y-m-d")
]);

The above doesn't seem to work at all.

[blueprint]

Resolved!

Use the "LIKE" operator which is "*" in EspoCRM. Thus:

$list = $this->getEntityManager()->getRepository($entityType)->where([
'createdAt*' => date("Y-m-d %:%:%")
]);

Works just fine.

[yuri]

'DAYOFMONTH:createdAt' => date('Y-m-d')

https://github.com/espocrm/documentation/blob/master/docs/user-guide/complex-expressions.md