P: Video capture time shifted by time zone offset

Since Android LRCC Mobile doesn't import or upload videos (see this thread), I've plugged my phone into my pc via usb. Then I use LRCC to import several videos. The problem is that , for all my imported videos, Lightroom CC shifts the Captured Date/Time  7 hours later than the actual Capture Date/Time. Seems like there must be a Time Zone setting in LRCC that I'm missing.

For example, this video, was captured on Oct-21-2017 at 4:06PM PST. However, LRCC desktop shows its capture date/time as Oct-21-2017 at 11:06PM. See the attached screen cap from LRCC. It shows the capture date 7 hours later than actual. 
. 


Specs:

• Android Samsung S7
• LR CC Mobile version 3.1
• LR CC Desktop version 1.0

No need to post a sample -- this is another example of the confusion caused by the poorly designed QuickTime spec, as described here: https://feedback.photoshop.com/photoshop_family/topics/canon-5d-mark-iv-video-capture-time-incorrect...

Hi,
Reviving this thread as the same issue exists on my new Sony a7rIII - camera shows correct timestamp for photos and video.  LR importing shifts timestamp for videos (but not photos) + 5 hours for EST.
Happy to post video to Dropbox
Thanks!

Good morning. We'd like to invite you to our prerelease if you're interested in evaluating a fix for this issue. Let us know and we'll get you added.

Thank you very much for your comprehensive explanation of the situation!

This sample video perfectly illustrates the industry video-metadata mess and where LR resides within that mess.

The capture date is recorded in different places in the file:

[QuickTime]  Create Date: 2017:05:24 14:58:35
[EXIF]  Date/Time Original: 2017:05:24 16:58:35
[MakerNotes] Time Zone: +02:00

(It helps to use “exiftool -a -G” to show where metadata fields are coming from.)   

QuickTime:CreateDate is the QuickTime/MPEG-4 standard field for recording capture date, and the spec calls for it to be recorded in UTC, which the camera has done.  But note that many, many cameras ignore the spec and write the date/time in local time, because the spec doesn’t specify a place to write the time zone and older cameras often did have any notion of time zone (shame on Apple originally and later on MPEG).  

EXIF:DateTimeOriginal is an industry-standard field for still photos but not videos.  In this case, it is coming from a thumbnail image stored in a non-standard Canon-specific location in the file, which you can verify by doing “exiftool -v”.  Other cameras don’t store metadata in this way.

MakerNotes:TimeZone is coming from the non-standard Canon-specific MakerNotes section, also stored in that thumbnail image. Some other cameras (but not all) record the time zone, but in other locations.

LR reads the industry-standard field QuickTime:CreateDate but treats it as local time rather than UTC (see above).  This is why it shows the wrong capture date for your videos.

It is definitely feasible for LR to handle video metadata better for mainstream cameras, but at considerably more engineering and legal expense. LR would need camera-specific rules for where to read and write metadata. Also, Adobe appears to have a very conservative legal approach to manufacturer-specific metadata, requiring legal agreements before incorporating such metadata in Adobe products. Up until very recently, Adobe has resisted this additional expense.  But LR now reads an Apple-specific time zone field for iPhones, and Adobe employees have indicated that they will do it for some Canons.

A sample photo and video from Canon Powershot G7X Mark II are available here:
https://www.magentacloud.de/share/62pfu6hgdm

Just updated my previous comment, which had some technical errors.