https://bugs.kde.org/show_bug.cgi?id=484708
Bug ID: 484708
Summary: Images.modificationDate value in the db is incorrect
Classification: Applications
Product: digikam
Version: 8.3.0
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: minor
Priority: NOR
Component: Database-Files
Assignee: digikam-bugs-n...@kde.org
Reporter: g...@zai.re
Target Milestone: ---
SUMMARY
. On Windows 10, using 8.3
. In the SQLite db, Images.modificationDate value is stored in this format
"2024-03-29T10:48:44.011Z"
. If I understand rightly the ISO 8601 standard, the final Z without offset
means UTC.
. But Digikam stores the modification date as local time and adds "Z" at the
end without taking account of the local time.
STEPS TO REPRODUCE
1. If your local time is not UTC, add or edit a caption of an image
2. Check of value Images.modificationDate field in the db (I use DB Browser for
SQLite)
OBSERVED RESULT
The value is a string which value is local time of that image, plus "Z" at the
end
If you need an extra confirmation, change the timezone of your computer in the
Windows settings, edit the caption and look at the field value.
EXPECTED RESULT
That value should be in UTC, taking account of the local timezone.
SOFTWARE/OS VERSIONS
Windows: 10
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
