Canon video UTC+3 contains correct data but 2 hours behind in Photos.app?

[Grouaaah]

Hello,

Thank you again for your help and your fast support! I still have an issue with sorting 22 videos over 800 elements from my trip to Africa (oof! This time, it's only 22!)

Indeed, I have taken 4K .MP4 videos with my Canon camera and I am sure the time was correctly set (UTC+3)? As I live in France my system's timezone is UTC+1. I don't know if Canon put timezone in videos, but it does for pictures. After checking, it seems that yes, it does. But I couldn't manage to find the option on the camera if the date is UTC or not for videos. I have the GP-E2 receiver.

My problem is that my video contains correct metadata at first sight, but it is a bit confused: [Canon] tag has no date but contains "timezone" UTC+03:00.
[IDF0] only has "modify date": 2024:01:24 13:35:35
[ExifIFD] has "numeric creation date/original creation date". 2024:01:24 13:35:35 WITH the timezone UTC+03:00.
[GPS] has the correct metadata. 10:35:09 UTC and 2024:01:24.
[UserData] has nothing about date.
[Track1] and [Track2] has UTC time: 10:35:35 ("Media create date", "Track create date"). But no timezone.


Every metadata seems correct on my video!
However, on Photos.app, it is displayed: 11:35:35 UTC+3.  and of course, shows up between 2 pictures taken at 11:30/11:40. When I edit the timezone in Photos.app it shows the good city so nothing points out any problem here.

?? So okay, it has the correct timezone but the time is 2 hours behind! Why please?


Thank you so much for your help, as always much appreciated. Have a nice day,

[Grouaaah]

Hello again (sorry if I posted at the wrong place, it was not intentional) I tried to use the command Matti gave me some time ago:

Code Select Expand

exiftool -api QuickTimeUTC=1 '-AllDates<FileName' '-Track*Date<FileName' '-Media*Date<FileName' '-Keys:CreationDate<FileName' -execute '-FileCreateDate<FileName' '-FileModifyDate<FileName' -common_args -m -P -overwrite_original_in_place -api largefilesupport=1 -wm w .
I had taken notes on this which are the following:
Remove -wm w to also create tags not originally present in the file! Useful to have the XMP tags, but also [Keys] and [UserData] which contain the time zone, so that Photos correctly places the videos among the photos!
This command will reset all dates in the video to the correct date and time (according to the name of the previously formatted file) and as the QuickTimeUTC=1 option is enabled, the times [QuickTime] and [Track], assumed to be in the same time zone as the system, will be automatically shifted to UTC+00:00. It is not recommended to set QuickTimeUTC=0, even if the file name is UTC+00:00, because the other dates (XMP for example) would not be at the correct time.
For Canon videos taken abroad when the camera was not in local time, the big command above is not enough: the [ExifIFD] and [IFD0] tags remain unchanged. To set them on time, you can use the command below, but you must set them one by one with GC12 Exif > Edit Exif Date. Warning: for certain videos that already have a time zone in these tags, it will be lost, and this command does not restore it (this is not the case with the Canon EOS 90D). Replace file with the file name.
exiftool -ThumbnailImage -b file | exiftool -time:all='YYYY:MM:DD hh:mm:ss' -TimeZone='+XX:xx' -wm w - | exiftool -ThumbnailImage'<=-' -wm w file
Finish with "Date... Set file creation & modification dates with Exif date".


But even with this, I wasn't able to let Photos.app understand that my video has to be displayed . Maybe something is missing somewhere but if UserData takes the advantage over the other tags to be displayed, I would like the metadata to be correct before inserting UserData into the file so there is no "bad" metadata hidden between prioritized tag in Photos.app

I noticed that it correctly shows up if I import the videos on Photos.app when my system is set on UTC+3, but not when on UTC+1. Very strange

Thank you very much for your help

[wywh]

Movie metadata is a mess and Canon ExifIFD:DateTimeOriginal in the thumbnails makes it even more messy.

I recommend using Keys:CreationDate because in Photos.app it overrides all other date tags.

In the following document search... "if you want to modify 'Keys:CreationDate' time zone, you might first have to create that tag with GraphicConverter 12" ...and also search... "In .mp4 and .mov 'Keys:CreationDate' time zone can be edited" ...and continue with GraphicConverter or exiftool:

https://discussions.apple.com/docs/DOC-250002750

- Matti

[StarGeek]

[Canon] tag has no date but contains "timezone" UTC+03:00.

From what I've seen in Canon (and Nikon) images is that the TimeZone is set to the time zone for the location you're taking pictures at, but you do not change this value when Daylight/Summertime happens.  Instead, there's a setting in the camera for Daylight Savings and you turn that on/off.  When on, the camera will automatically adjust the date/time data.

[Grouaaah]

Yes, I read this article and it helped me a lot, I remember. Thank you very much! I now need to change the "inode change date of file", "last access date" and "last opened date"

Thank you for your help!

[StarGeek]

There's no point in changing the FileAccessDate (not that exiftool can do so).  It will be automatically updated whenever the file is touched in any way.

[Grouaaah]

Okay, thank you for your answer, and can I change the "last opened" date and "inode change date"?

I solved my problem with my videos, thanks for all your answers!

[wywh]

can I change the "last opened" date and "inode change date"

There's no point in changing them. Most importantly just set:

QuickTime:CreateDate
Keys:CreationDate [if it exists]

If you insist, you might set these the same date:

MacOS:FileCreateDate
System:FileModifyDate
UserData:DateTimeOriginal [if it exists]
QuickTime:*Date [ModifyDate, TrackCreateDate, TrackModifyDate, MediaCreateDate, MediaModifyDate]

- Matti