Format Where Clause with comparison interval in ORM

[czcpf]

Hello,

The following code does not work. How do I create this query using ORM syntax ?

->where([
'evaluationDate>' => 'DATE_SUB(NOW(),INTERVAL 11 YEAR)',
])​ 

Currently, this query gives me the following error:

ERROR: (HY000) SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: 'DATE_SUB(NOW(),INTERVAL 11 YEAR))'

This is odd to me since the following code works directly in mysql

SELECT
*
FROM
`equipment_performance_evaluation_report`
WHERE
`evaluation_date` > DATE_SUB(NOW(), INTERVAL 11 YEAR)​

[yuri]

Advice, do it in PHP, pass a result string-date.

[yuri]

'evaluationDate>' => (new \DateTimeImmutable)->modify('-11 years')->format('Y-m-d H:i:s'),

[czcpf]

Thanks for the suggestion. I thought maybe something clever like complex expression TIMESTAMPDIFF_YEAR could be useful and tried building Expression with it but Expression::TIMESTAMPDIFF_YEAR does not exist. I didn't know about DateTimeImmutable but that is useful. I ended up just doing it in PHP the old-fashioned way.

$retentionDate = date("Y-m-d", strtotime("-11 years")); 

->where([
'evaluationDate>' => $retentionDate,
])​