Apple macOS Photos sorting mp4 files 1 hour earlier - time zone problem? (S120)

[boombass]

I used a Canon S120 to take some photos and videos. When I import them into Apple Photos, the video files appear 1 hour earlier than taken when sorted by time. Is this a daylight savings time issue? Can I fix this with ExifTool so that they sort correctly?

Here are the results of "exiftool -time:all -a -G0:1 -s " on a photo and an mp4 file taken within minutes of each other:

Photo:

Code Select Expand


[File:System]   FileModifyDate                  : 2017:12:11 18:57:38-07:00
[File:System]   FileAccessDate                  : 2017:12:19 10:15:21-07:00
[File:System]   FileInodeChangeDate             : 2017:12:19 10:08:04-07:00
[EXIF:IFD0]     ModifyDate                      : 2017:12:11 18:57:38
[EXIF:ExifIFD]  DateTimeOriginal                : 2017:12:11 18:57:38
[EXIF:ExifIFD]  CreateDate                      : 2017:12:11 18:57:38
[MakerNotes:Canon] TimeZone                     : -06:00
[MakerNotes:Canon] TimeZoneCity                 : (not set)
[MakerNotes:Canon] DaylightSavings              : On


mp4:

Code Select Expand


[File:System]   FileModifyDate                  : 2017:12:11 19:01:26-07:00
[File:System]   FileAccessDate                  : 2017:12:19 10:14:35-07:00
[File:System]   FileInodeChangeDate             : 2017:12:19 10:08:29-07:00
[EXIF:IFD0]     ModifyDate                      : 2017:12:11 19:01:26
[EXIF:ExifIFD]  DateTimeOriginal                : 2017:12:11 19:01:26
[EXIF:ExifIFD]  CreateDate                      : 2017:12:11 19:01:26
[MakerNotes:Canon] TimeZone                     : -06:00
[MakerNotes:Canon] TimeZoneCity                 : (not set)
[MakerNotes:Canon] DaylightSavings              : On
[QuickTime]     CreateDate                      : 2017:12:11 19:01:26
[QuickTime]     ModifyDate                      : 2017:12:12 01:01:26
[QuickTime:Track1] TrackCreateDate              : 2017:12:12 01:01:26
[QuickTime:Track1] TrackModifyDate              : 2017:12:12 01:01:26
[QuickTime:Track1] MediaCreateDate              : 2017:12:12 01:01:26
[QuickTime:Track1] MediaModifyDate              : 2017:12:12 01:01:26
[QuickTime:Track2] TrackCreateDate              : 2017:12:12 01:01:26
[QuickTime:Track2] TrackModifyDate              : 2017:12:12 01:01:26
[QuickTime:Track2] MediaCreateDate              : 2017:12:12 01:01:26
[QuickTime:Track2] MediaModifyDate              : 2017:12:12 01:01:26
[XMP:XMP-xmp]   CreateDate                      : 2017:12:11 19:01:26


Same TimeZone tag for each, but they differently. Any ideas why? How can I use ExifTool to fix this?

[Phil Harvey]

Try setting the -api QuickTimeUTC option when running on the MP4 files.  See here for the API option documentation.

- Phil

Edit: After actually reading your post I see that your problem is with Apple Photo, not ExifTool.  You can use ExifTool to adjust the appropriate times if necessary, but other than that I don't see a solution.

- Phil

[Hayo Baan]

Phil's probably right about an oversight in Photos. But can you show us the output out the video times when applying the -api QuickTimeUTC option? That will show us what is recorded at utc time (which is likely what Photos is using). It could be your camera just records it wrong...

[boombass]

Thanks for your help! Here are the results of "exiftool -api QuickTimeUTC -time:all -a -G0:1 -s" on the same files:

photo:

Code Select Expand


[File:System]   FileModifyDate                  : 2017:12:11 18:57:38-07:00
[File:System]   FileAccessDate                  : 2017:12:20 12:31:10-07:00
[File:System]   FileInodeChangeDate             : 2017:12:20 12:31:09-07:00
[EXIF:IFD0]     ModifyDate                      : 2017:12:11 18:57:38
[EXIF:ExifIFD]  DateTimeOriginal                : 2017:12:11 18:57:38
[EXIF:ExifIFD]  CreateDate                      : 2017:12:11 18:57:38
[MakerNotes:Canon] TimeZone                     : -06:00
[MakerNotes:Canon] TimeZoneCity                 : (not set)
[MakerNotes:Canon] DaylightSavings              : On


mp4:

Code Select Expand

[File:System]   FileModifyDate                  : 2017:12:11 19:01:26-07:00
[File:System]   FileAccessDate                  : 2017:12:11 19:01:26-07:00
[File:System]   FileInodeChangeDate             : 2017:12:20 12:31:09-07:00
[EXIF:IFD0]     ModifyDate                      : 2017:12:11 19:01:26
[EXIF:ExifIFD]  DateTimeOriginal                : 2017:12:11 19:01:26
[EXIF:ExifIFD]  CreateDate                      : 2017:12:11 19:01:26
[MakerNotes:Canon] TimeZone                     : -06:00
[MakerNotes:Canon] TimeZoneCity                 : (not set)
[MakerNotes:Canon] DaylightSavings              : On
[QuickTime]     CreateDate                      : 2017:12:11 18:01:26-07:00
[QuickTime]     ModifyDate                      : 2017:12:11 18:01:26-07:00
[QuickTime:Track1] TrackCreateDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track1] TrackModifyDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track1] MediaCreateDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track1] MediaModifyDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track2] TrackCreateDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track2] TrackModifyDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track2] MediaCreateDate              : 2017:12:11 18:01:26-07:00
[QuickTime:Track2] MediaModifyDate              : 2017:12:11 18:01:26-07:00


[Phil Harvey]

OK.  The hour difference seems be be because your camera was set to a time zone of -06:00, but your system is -07:00.

And as you said, the QuickTime date/time tags are one hour off the local date/time values in the JPG EXIF.

Try this to fix the times in the MP4 files:

exiftool -quicktime:time:all+=1 -ext mp4 DIR

- Phil

[boombass]

I just got around to doing this after a busy Christmas, and it worked! Thank you very much for your help!