Details
-
Bug
-
Resolution: Done
-
P3: Somewhat important
-
None
-
4.8.0
-
None
-
9e64fc9e1cebf1e11694c4f536881128f5aee288
Description
Since QDate, QDateTime and QTime are converted to string, by using QVariant's toString(), in order to bind it to the sqlite3 context, milliseconds are ignored. I guess, QVariant::toString() uses the Qt::ISODate format.
QTime and QDateTime should be treated separatly and should be converted using yyyy-MM-ddThh:mm:ss.zzz or hh:mm:ss.zzz as format to cover the milliseconds.
See file qsql_sqlite.cpp - line 391-402