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:
[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:
[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?
Try setting the -api QuickTimeUTC option when running on the MP4 files. See here (https://exiftool.org/ExifTool.html#QuickTimeUTC) 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
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...
Thanks for your help! Here are the results of "exiftool -api QuickTimeUTC -time:all -a -G0:1 -s" on the same files:
photo:
[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:
[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
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
I just got around to doing this after a busy Christmas, and it worked! Thank you very much for your help!