[Digikam-devel] [Bug 246401] Improve date based sort of camera interface: use more time precision from Exif when shots are taken with less than 1s

Marcel Wiesweg marcel.wiesweg at gmx.de
Tue Aug 9 18:24:10 BST 2011


https://bugs.kde.org/show_bug.cgi?id=246401





--- Comment #10 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-08-09 17:24:10 ---
We use the SQL data type DATETIME. For SQLite, this is simply a string . This
string is created using QDateTime::toString/fromString with Qt::ISODate:
"2011-08-09T19:14:09.123"
QTime has a field for microseconds. QDateTime::toString will never append the
microseconds, but fromString correctly parses them. This means with a custom
toString(), including the microseconds would be fully backwards compatible.

Francesco, any considerations for MySQL and the DATETIME type? The code
generating a QString in AlbumDB is the same.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Digikam-devel mailing list