Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-102

SQLSRV PDO doesn't support DateTime as a PHP Object

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.1.3
    • Component/s: Drivers
    • Labels:
      None
    • Environment:
      Windows 7, Microsoft SQL Server 2008, PHP SqlSrv Driver 2.0, PHP 5.3.6

      Description

      I have created an entity with has a datetime column

      Entity.php
          /**
           * @orm:Column(name="deleteAt", type="datetime")
           */
          protected $deletedAt;
      
          /**
           * Get DeletedAt
           * @return	\DateTime	
           */
          public function getDeletedAt() {
          	return $this->deletedAt;
          }
          
          /**
           * Set DeletedAt
           * @param	\DateTime		$deletedAt
           */
          public function setDeletedAt(\DateTime $deletedAt) {
              $this->deletedAt = $deletedAt;
          }
      

      This should work, however I get this error when trying to set a "deleteAt" date

      $this->setDeletedAt(new \DateTime());
      
      SQLSTATE[22007]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string.
      

      This should work afaik.

        Activity

          People

          • Assignee:
            Guilherme Blanco
            Reporter:
            Aaron DM
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: