title: Symfony2 & MSSQL Server persisting dates
body: <p>I have an Entity with a column "fecha" (datetime) mapped to an SQL Server database.
  When I try to persist to the database, an error raise:</p>
  
  <blockquote>
    <p>An exception occurred while executing 'UPDATE tor_jornada SET fecha =
    ?, cancha = ? WHERE id = ?' with params ["2014-09-14 00:00:00.000000",
    1, 286]:</p>
    
    <p>SQLSTATE[22007]: [Microsoft][SQL Server Native Client 11.0][SQL
    Server]Conversion failed when converting datetime from character
    string.</p>
  </blockquote>
  
  <p>When I put the query in the SQL Server Management, it raise an error.
  Then I cut the right zeros in the milliseconds, change "2014-09-14 00:00:00.000000" to "2014-09-14 00:00:00.00" and it works fine!</p>
  
  <p>So, can I change this in Symfony? How? Where?</p>
  
  <p>The entity:</p>
  
  <pre><code>namespace IM\ManTorneosBundle\Entity;
  
  use Doctrine\ORM\Mapping as ORM;
  
  /**
   * TorJornada
   *
   * @ORM\Table(name="tor_jornada", indexes={@ORM\Index(name="IDX_AB7D06987CEB63FE", columns={"torneo"})})
   * @ORM\Entity
   */
  class TorJornada
  {
      /**
       * @var integer
       *
       * @ORM\Column(name="id", type="integer", nullable=false)
       * @ORM\Id
       * @ORM\GeneratedValue(strategy="IDENTITY")
       */
      private $id;
  
      /**
       * @var integer
       *
       * @ORM\Column(name="jornada", type="integer", nullable=false)
       */
      private $jornada;
  
      /**
       * @var \DateTime
       *
       * @ORM\Column(name="fecha", type="datetime", nullable=false)
       */
      private $fecha;
  
   .....
  </code></pre>