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

Question

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()?

Solution found. Just pass third argument array('datetime') to the insert() method. Use 'datetime' for DateTime, PDO::PARAM_STR for strings and PDO::PARAM_INT for integers. — Slava Fomin II
– Slava Fomin II, Commented Apr 4, 2012 at 15:12

Slava Fomin II · Accepted Answer · 2013-09-30 21:10:41Z

26

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

Did the trick! ))

edited Sep 30, 2013 at 21:10

answered Apr 5, 2012 at 9:21

Slava Fomin II

29k36 gold badges136 silver badges208 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dimitry K Over a year ago

What about the order of the elements in the first array? I presume when array of key-value pairs is declared right as function argument, the order of the keys will match the order of them being declared, however what if key-value pair array is created dynamically by some other function?

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related