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

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

      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

        1. main.cpp
          2 kB
        2. OracleDateTest.cpp
          2 kB
        3. qt-5.15-QTBUG-76573-OCI-invalid-timezone-with-DATE.patch
          2 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

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

              Created:
              Updated:

                There are no open Gerrit changes