https://bugs.kde.org/show_bug.cgi?id=491608
--- Comment #9 from mahikeulbody <mcfaro...@gmail.com> ---
Crash fixed, thanks.
Coming back to the request to see what happen now with video times :
I have a pixel 5 video where exiftool -Time:all => "2024:05:02 02:29:59" for
all date fields of the file (it is the right UTC time of the video).
I added it to Digikam and I checked the ImageInformation table into the SQLite
db :
creationDate : 2024-05-02T04:29:59.000
digitizationDate : 2024-05-02T04:29:59.000
(Digikam applied the time zone of my computer, UTC+2)
Than I want to 'Adjust Time & Date' of the video to the local time in order :
1) that it is sorted correctly compared to the photos when "View/Sort items/by
creation date"
2) it can be renamed with a date pattern based on the local time in order to be
sorted correctly with the photos when "View/Sort items/by Name".
The video has been taken in South Korea, UTC+9. So I must adjust by +7 hours
(-2+9). Checking the db after the adjust :
creationDate : 2024-05-02T11:29:59.000
digitizationDate : 2024-05-02T04:29:59.000
Now I try to sort items by Creation date : ok ; by Name : ok. Nice !
But exiftool -Time:all => "2024:05:02 09:29:59" for the date fields of the
file. That is logical but annoying since QuickTime:CreateDate is supposed to be
UTC time. What will happen if we import later these "adjusted" videos into a
new Digikam collection ? I think that this solution can lead to a lot of
confusion for the user.
That is why, as suggested in https://exiftool.org/forum/index.php?topic=16289.0
topic, I proposed that "Adjust Time & date" writes the adjusted time into the
field QuickTime:CreationDate which supports an offset (in my example, the value
to write would be 2024-05-02 02:29:59+09:00) and to store it into
db.creationDate (for sorting and renaming purposes). Additionally, Digikam
would use QuickTime:CreationDate, if it exists, instead of
QuickTime:CreationDate when reading metadatas from file.
To be sure that is possible, I tried :
exiftool -QuickTime:CreationDate="2024:05:02 02:29:59+09:00" myfile.mp4
I get:
"QuickTime": {
"CreateDate": "2024:05:02 09:29:59",
"ModifyDate": "2024:05:02 09:29:59"
},
"Keys": {
"CreationDate": "2024:05:02 02:29:59+09:00"
},
According to my understanding of the topic linked above, it seems Apple uses
this solution so solve the problem.
--
You are receiving this mail because:
You are watching all bug changes.
