movies from iPhone have wrong (offset) CreateDate

Started by rroonnbb, January 26, 2019, 06:14:40 PM

Previous topic - Next topic

rroonnbb

I'm trying to figure out if this is an exiftool or iOS issue but when I pull movies created on my iPhone (XS running 12.1.2) onto my Mac (Mini, running 10.14.3), I'm finding that exiftool shows a CreateDate that's 8 hours later than it should be (I'm in California, so +8 is GMT)

ron$ exiftool -s IMG_3161.MOV | grep Date
FileModifyDate                  : 2019:01:26 14:43:38-08:00
FileAccessDate                  : 2019:01:26 14:50:30-08:00
FileInodeChangeDate             : 2019:01:26 14:45:58-08:00
CreateDate                      : 2019:01:26 22:43:38
ModifyDate                      : 2019:01:26 22:43:38
TrackCreateDate                 : 2019:01:26 22:43:38
TrackModifyDate                 : 2019:01:26 22:43:38
MediaCreateDate                 : 2019:01:26 22:43:38
MediaModifyDate                 : 2019:01:26 22:43:38
CreationDate                    : 2019:01:26 14:43:38-08:00

CreationDate shows the correct time (in this case 2:43pm) but I'd rather not use that tag since I'm trying to write a script that works for several different filetypes and it would just be more cumbersome. (And yes, there's plenty of workarounds... I just want to confirm that this is actually a bug and/or if I'm just not thinking about this properly.)  Should also state that JPEGs coming from the same phone show the correct CreateDate, etc. so at the very least this is an inconsistency.

Oh, and my exiftool = v11.26

Here's a link to the movie (500KB): https://www.dropbox.com/s/m5h8wm4n789311r/IMG_3161.MOV?dl=0

StarGeek

If you add the group names (-g1) to the command, then you will see that the CreateDate is in the Quicktime group.  The timestamps in that group are supposed to be in UTC time (see third paragraph under Quicktime Tags).  So technically, it's correct according to the specs.  If you add -api QuickTimeUTC to the command, exiftool should make the correction for you.

Also, you can just use -*date* to only extract tags with "date" in the name rather than piping through grep.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

rroonnbb

Ahh, nice! Makes total sense. MUCH appreciated!