Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-397

PostgreSQL - getDateTimeTzFormatString()

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: 2.3.1
    • Fix Version/s: None
    • Component/s: Platforms
    • Environment:
      PostgreSQL Database

      Description

      In:

      • vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/PostgreSqlPlatform.php

      The function:

      getDateTimeTzFormatString()

      only returns one datetime format:

      
          /**
           * {@inheritDoc}
           */
          public function getDateTimeTzFormatString()
          {
              //return 'Y-m-d H:i:sO'; // original format
              return 'Y-m-d H:i:s.uO'; // format also needed
          }
      
      
      

      Here is the error I get using the original format:

      Could not convert database value "2012-12-07 16:01:52.580789-05" to Doctrine Type datetimetz. Expected format: Y-m-d H:i:s.O

      If I use this format: 'Y-m-d H:i:s.uO' it works.

        Activity

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Phill Pafford
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: