I'm using Doctrine 2.2 with php 5.3 on an apache server.
So far I've stumbled upon the following problem: When I try to update a datetime column I get: SQLSTATE[22007]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string.
I've even gone so far to make a get onto the column and then use that with only 1 day added to it to set the new date......same result.
When I instead change both the column in the database and in the entity from datetime to date, it functions as intended.
My main problem is, that there are a few fields where I will NEED to use a datetime column.
Here's my code:
(birthdate was the column I changed to date....and is one of the few columns where that is possible for me):
//This returns the datetime object that represents birthdate from the database
$help=$object->getBirthDate();
$help->setTimestamp(mktime($time[0],$time[1],$time[2],$date[2],$date[1],$date[0]));
$help->format(\DateTime::ISO8601);
$object->setBirthDate($help);
Does someone know a workaround here?