Details
-
Suggestion
-
Resolution: Out of scope
-
P5: Not important
-
4.4.0
-
None
Description
QSqlTableModel uses the local date time format which is usually different from the database date time format. (e.g. ISO yyyy-mm-dd in case of PostgreSQL). SQL search filters will not work correctly if users are not aware of the database format and try to use the same format the view is displaying (e.g US dd/mm/yyyy ).
It would be nice to be able to set the date time format for the QSqlTableModel (database or local format) and have complete application compatibility with DB, in any locales.