using insert() method to insert DateTime value with PHP Doctrine\DBAL 2

database, datetime, dbal, doctrine-orm, php

Solution

$DB->insert('table_name', [
    'foo'   => 'foo',
    'bar'   => 17,
    'field' => new \DateTime(),
], [
    PDO::PARAM_STR,
    PDO::PARAM_INT,
    'datetime',
]);

Did the trick! ))

Problem

How can i pass PHP's DateTime object as a value for database field using Doctrine\DBAL? $DB is a Doctrine\DBAL\Connection instance. ``` $DB->insert('table_name', [ 'field' => new \DateTime(), ]); // Catchable fatal error: Object of class DateTime could not be converted to string ``` The code above is not working and documentation is scarce. I knew for sure that you can provide DateTime objects directly using another DBAL methods, is it possible to do this with insert()?

Original source