i have a problem when i want query a row in my mysql database.
The ‘p_release_date’ field is type with datetime with doctrine. And after an insert, the format is 2023-03-24 00:00:00.
When i click on my Vue.js component, it return a date like this :
Fri Mar 24 2023 06:05:00 GMT+0100 (heure normale d’Europe centrale)
I transform my date in PHP DateTime :
$datetime = DateTime::createFromFormat('D M d Y H:i:s e+', $datas['date']);
$datetime->settime(0, 0);
Then when i made my query, the response return nothin, and i have infinite process on my network devtool :
$projects = $this->em->getRepository(Project::class)->findBy(['release_date' => $datetime]);
If someone has an issue, it will be useful.
Thanks a lot and have a nice day.
I try to made a query with doctine on my mysql table, filter by DateTime.
Currently it return nothin and a infinite process.
I expected it returns rows.