Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Postgis Timestamps from query in DB Manager displayed as `PyQT5.QTCore.QDateTime(2020, 3, 17, ... #35140

Closed
dd-a opened this issue Mar 17, 2020 · 4 comments · Fixed by #37042
Closed

Postgis Timestamps from query in DB Manager displayed as `PyQT5.QTCore.QDateTime(2020, 3, 17, ... #35140

dd-a opened this issue Mar 17, 2020 · 4 comments · Fixed by #37042
Assignees
@elpaso
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin High Priority Regression Something which used to work, but doesn't anymore

Comments

@dd-a
Copy link

dd-a commented Mar 17, 2020

Since QGis 3.12, timestamps from Postgis query in DB Manager are displayed as something like PyQT5.QTCore.QDateTime(2020, 3, 17, ...

Example
SELECT now() gives PyQT5.QTCore.QDateTime(2020, 3, 17, 14, 56, 27, 629, PyQT5.QTCore.QT.TimeSpec(1))

Seen with QGis 3.12 on Mac OS 10.15 (and also Mac OS 10.13)

Version de QGIS 3.12.0-București Révision du code 409bcf8
Compilé avec Qt 5.12.3 Utilisant Qt 5.12.3
Compilé avec GDAL/OGR 2.4.1 Utilisé avec GDAL/OGR 2.4.1
Compilé avec GEOS 3.7.2-CAPI-1.11.2 Utilisé avec GEOS 3.7.2-CAPI-1.11.2 b55d2125
Compiled against SQLite 3.28.0 Running against SQLite 3.28.0
Version du client PostgreSQL 11.3 Version de SpatiaLite 4.3.0a
Version de QWT 6.1.4 Version de QScintilla2 2.11.1
Compilé avec PROJ 5.2.0 Fonctionne avec PROJ Rel. 5.2.0, September 15th, 2018
OS Version macOS 10.15
@dd-a dd-a added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Mar 17, 2020
@gioman
Copy link
Contributor

gioman commented Mar 17, 2020

@dd-a meaning that in 3.10.3 are OK?

@gioman gioman added Feedback Waiting on the submitter for answers DB Manager Relating to the DB Manager core plugin labels Mar 17, 2020
@dd-a
Copy link
Author

dd-a commented Mar 17, 2020

yes, it's ok in 3.10.3 . I just checked.

@gioman gioman added Regression Something which used to work, but doesn't anymore High Priority and removed Feedback Waiting on the submitter for answers labels Mar 17, 2020
@elpaso elpaso self-assigned this Jun 8, 2020
@elpaso
Copy link
Contributor

elpaso commented Jun 8, 2020 •
edited
Loading

Would this be ok?

qgis-dbmanager-datetime

qgis-dbmanager-datetime-2

elpaso added a commit to elpaso/QGIS that referenced this issue Jun 8, 2020
@elpaso
Fix DB manager date time display in SQL window
3d6c345 
Fixes qgis#35140
@elpaso elpaso mentioned this issue Jun 8, 2020
Merged
@elpaso
Copy link
Contributor

elpaso commented Jun 8, 2020

@gioman and @dd-a if you have a minute can you please test this PR: #37042 (it's just a few python lines change)

nyalldawson pushed a commit that referenced this issue Jun 8, 2020
@elpaso @nyalldawson
Fix DB manager date time display in SQL window
21f6f57 
Fixes #35140
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@elpaso elpaso

Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin High Priority Regression Something which used to work, but doesn't anymore
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix DB manager date time display in SQL window elpaso/QGIS
3 participants
@elpaso @gioman @dd-a