Update the day of several recorded dates - CakePHP / Postgres

Need Help
1

Hello!
I am new using the CakePHP framework, in this opportunity I find the following problem: I need to modify the day of several dates registered in bd (postgresql).

I thought about extracting the day from the date that comes from the form and assembling the new date taking only the year and the month of the date already registered, all this with date_part(), something like this:

$ndate = $this->request->getData()['expired'];
$newDate =  "(date_part('year', expired) || '-' || date_part('month', expired) || '-' || date_part('day', '$ndate'::date))::date";

$fields += array('expired' => $newDate);

if ($this->Payments->updateAll($fields,$options)){
    $a = true;
    $rFlash ='Successfully updated payments';
}

I tried the resulting full query in pgAdmin and it works fine … the problem (at least that’s what I think ;-P) is with cakePHP, which gives me the following error message:

Database Error
PDOException

Error: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: "(date_part("year", expired) || - || date_part("month", expired) || - || date_part("day", 2018-08-05::datetime))::datetime"

I thank you in advance for all the help you can give me.

2

You need to extract daypart from the new date and then pass it to the below code:
$days = 25;//extract daypart from the new date
$newDate = “expired + ($days-EXTRACT(DAY FROM expired) || ’ days’)::interval”;
$fields = array(‘expired’ => $newDate);
$this->Payments->updateAll($fields, $options);