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

        Aaron DM created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Assignee Benjamin Eberlei [ beberlei ] Juozas Kaziukenas [ juokaz ]
        Guilherme Blanco made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Assignee Juozas Kaziukenas [ juokaz ] Guilherme Blanco [ guilhermeblanco ]
        Fix Version/s 2.1.3 [ 10162 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 12476 ] jira-feedback2 [ 17704 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17704 ] jira-feedback3 [ 20059 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: