[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

[Francesco Riosa]

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





--- Comment #13 from Francesco Riosa <francesco+kde pnpitalia it>  2011-08-10 23:46:54 ---
(In reply to comment #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.

no support for milliseconds or better in mysql, need to fake it with an
additional INT column :(

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