Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-76573

QSqlQuery sets the timezone on QDateTime after a SQL SELECT on a DATE field (Oracle datatype)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • P2: Important
    • None
    • 5.12.3
    • SQL Support
    • None
    • All

    Description

      QSqlQuery sets the timezone on QDateTime after a SQL SELECT on a DATE field (Oracle datatype) although this datatype does not contain timezone information.

      This behaviour was introduced after this QTBUG : https://bugreports.qt.io/browse/QTBUG-46271

      As explained in this issue, only those fields should have been impacted :

      • TIMESTAMP WITH TIMEZONE
      • TIMESTAMP WITH LOCAL TIMEZONE

      Not :

      • TIMESTAMP
      • DATE

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-46271 QOCI driver does not handle timezone information

          • P3: Somewhat important - Should be fixed, but doesn't affect the release in any way.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              mabrand Mark Brand
              a.cornille Alexandre CORNILLE
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes