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

        Phill Pafford created issue -
        Phill Pafford made changes -
        Field Original Value New Value
        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.




            
        In:

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

        The function:

            getDateTimeTzFormatString()

        only returns one datetime format:

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

        </code></pre>

        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.




            
        Fabio B. Silva made changes -
        Description In:

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

        The function:

            getDateTimeTzFormatString()

        only returns one datetime format:

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

        </code></pre>

        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.




            
        In:

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

        The function:

            getDateTimeTzFormatString()

        only returns one datetime format:
        {code}
        <pre><code>
            /**
             * {@inheritDoc}
             */
            public function getDateTimeTzFormatString()
            {
                //return 'Y-m-d H:i:sO'; // original format
                return 'Y-m-d H:i:s.uO'; // format also needed
            }

        </code></pre>
        {code}

        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.




            
        Benjamin Eberlei made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]
        Phill Pafford made changes -
        Description In:

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

        The function:

            getDateTimeTzFormatString()

        only returns one datetime format:
        {code}
        <pre><code>
            /**
             * {@inheritDoc}
             */
            public function getDateTimeTzFormatString()
            {
                //return 'Y-m-d H:i:sO'; // original format
                return 'Y-m-d H:i:s.uO'; // format also needed
            }

        </code></pre>
        {code}

        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.




            
        In:

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

        The function:

            getDateTimeTzFormatString()

        only returns one datetime format:
        {code}

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


        {code}

        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.




            

          People

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

            Dates

            • Created:
              Updated:
              Resolved: