Bug 447371 - Date of videos seems incorrect
Summary: Date of videos seems incorrect
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Metadata-Video (show other bugs)
Version: 7.4.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-22 06:23 UTC by pmgying
Modified: 2022-04-10 21:43 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 8.0.0

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description pmgying 2021-12-22 06:23:43 UTC 
Dates in metadata (e.g. EXIF date and time values) in images seems *correct*.
However, dates of videos (EXIF "Date and Time" variances, ExifTool "MediaCreateDate" etc.) seems to be incorrect.
More specifically, it looks like the date values of videos are bumped up by my timezone.
e.g. I am on EST (-5). If a video is taken at 01:20, the values appear in digikam becomes 06:20.

The photos/videos are taken on an Android phone.
Checking the date information in Google Photo, and the dates looks correct to me.

STEPS TO REPRODUCE
1. Browse a video
2. Look at the date values in Metadata

OBSERVED RESULT
Most Date/Times are "time zone hours" ahead, i.e. the time in photo seems to be treated as UTC if it is not coincident.
The only correct dates I see are "File*Date" under "ExifTool"

EXPECTED RESULT
Date/Time should be correct.

SOFTWARE/OS VERSIONS
Windows: 10
Comment 1 pmgying 2021-12-22 06:35:19 UTC 
I would like to add that the dates of videos during EDT (datelight saving time : -4) is exactly 4 hours ahead.
And the ones now (EST: -5) are exactly 5 hours ahead.
So it must be caused by timezone interpretation issue.

(Sorry if this is not digikam's issue. Since I have no other means to check EXIF data, I can only trust Google Photo App or DigiKam. And Google photo app is showing the right time to me.)
Comment 2 caulier.gilles 2021-12-22 06:46:01 UTC 
Video dates are take by digiKam using ffmpeg. You ca double check from CLI using "ffmpeg -i video_file"
By comparison, look also the result with ExifTool from CLI.

Gilles Caulier
Comment 3 caulier.gilles 2021-12-22 06:46:59 UTC 
Arf, sorry, i just seen that you use Windows, not Linux... Forget my previous comment (:=)))
Comment 4 Maik Qualmann 2021-12-22 06:53:56 UTC 
The video date has a long history at digiKam. Yes, when we detect an Android video, we use the time zone. You should then have the correct local time. We have received test videos from users with logs of what time a video was recorded and what digiKam detects. As a result, it was shown that the time zone must be observed on an Android device.

Maik
Comment 5 Maik Qualmann 2021-12-22 06:55:52 UTC 

*** This bug has been marked as a duplicate of bug 432369 ***
Comment 6 Maik Qualmann 2021-12-22 07:45:35 UTC 
Please send a test video, if not public, to my email address. The best thing to do is to film a watch to see if digiKam is detecting the correct time.

Maik
Comment 7 caulier.gilles 2022-04-10 21:43:07 UTC 
The video metadata including date will be taken from file using ExifTool, instead Exiv2 and ffmpeg. this must solve your problem.