Archive 2022 · Data/Time metadata for video files

dclark
Offline
• • • • •
Upload & Sell: On

p.1 #1 · p.1 #1 · Data/Time metadata for video files

The video files I get using my Sony A1 have date/time metadata set to GMT, not the local time zone set in my camera. Lightroom shows "Date Time Digitized" and "Metadata Date" that is 7 hours ahead of PDT, which is GMT. There is another piece of metadata "Date Time" that is 4hr 30min ahead. That would be a time zone somewhere in the middle of the Atlantic, which makes no sense. There is also an accompanying small JPEG file that has the correct date/time metadata.

This is a bit of a PITA since still and video files are sorted in different order and the JPEG associated with the video files are not along side the video file. Video files can have a date/time that is the following day and consequently end up in a different folder the way I automatically organize files when downloading.

I can't find any camera settings to set the date/time metadata for video files to local time. Is there a way to get the correct local time in the video file metadata other than editing the metadata for each file?

Dave

Jun 24, 2022 at 11:55 PM

Slalom
Offline
• • •
Upload & Sell: On

p.1 #2 · p.1 #2 · Data/Time metadata for video files

I don't have an A1, but on an a9 there is an area setting next to the date/time in settings. documentation says area of use.

taken from user guide, not playing with settings myself

Jun 25, 2022 at 04:50 AM

dclark
Offline
• • • • •
Upload & Sell: On

p.1 #3 · p.1 #3 · Data/Time metadata for video files

Slalom wrote:
I don't have an A1, but on an a9 there is an area setting next to the date/time in settings. documentation says area of use.

taken from user guide, not playing with settings myself

Yes, I have that set for PDT. All my still image files have the correct date/time metadata.

Jun 25, 2022 at 08:01 AM

osv2
Offline
• • • •
[X]

p.1 #4 · p.1 #4 · Data/Time metadata for video files

dclark wrote:
The video files I get using my Sony A1 have date/time metadata set to GMT, not the local time zone set in my camera.
Lightroom shows "Date Time Digitized" and "Metadata Date" that is 7 hours ahead of PDT, which is GMT. There is another piece of metadata "Date Time" that is 4hr 30min ahead.

when i look at a1 video xml files that are on the sd card i don't see those fields.

for instance on the sd card it's 'CreationDate value="2022-06-25T08:37:55-07:00"' for what i shot earlier today, which is correct... i don't know what "07:00" corresponds to, but it's not off by 4hr 30min.

i'm shooting: 'videoCodec="HEVC_3840_2160_M42210P@L51HT"'

the jpeg framegrab also has the correct date/time.

Jun 25, 2022 at 11:10 AM

dclark
Offline
• • • • •
Upload & Sell: On

p.1 #5 · p.1 #5 · Data/Time metadata for video files

osv2 wrote:
when i look at a1 video xml files that are on the sd card i don't see those fields.

for instance on the sd card it's 'CreationDate value="2022-06-25T08:37:55-07:00"' for what i shot earlier today, which is correct... i don't know what "07:00" corresponds to, but it's not off by 4hr 30min.

i'm shooting: 'videoCodec="HEVC_3840_2160_M42210P@L51HT"'

the jpeg framegrab also has the correct date/time.

The 07:00 corresponds to the time offset between PDT and GMT.

Jun 25, 2022 at 11:59 AM

dclark
Offline
• • • • •
Upload & Sell: On

p.1 #6 · p.1 #6 · Data/Time metadata for video files

I think this is probably a combination of how the camera records metadata and how Lightroom displays the metadata. I probably should have posted this question in the Post Processing forum. Unfortunately I see no way to move it or to cross post it once the thread has been initiated.

It seems that the issue is that LR puts GMT(UTC) into the date/time fields for video files but puts local time (in my case PDT) in the date/time fields for still images. I would prefer that video files be handled in the same way photographs are handled but I see no way to get LR to do that. Where the 4.5 hour offset for one of the date/time fields comes from is a mystery to me.

It is also worth noting that the date/time recorded for the JPEG (which is the first frame of the video) is when the video clip starts, but the date/time recorded for the video file is when the video clip ends.

Jun 25, 2022 at 12:12 PM

osv2
Offline
• • • •
[X]

p.1 #7 · p.1 #7 · Data/Time metadata for video files

as near as i can tell the data in question was put there by adobe and possibly written into the lightroom catalog, not the video files nor the video sidecar files, which is problematic... fwiw: http://lightroomsolutions.com/plug-ins/jb-video-metadata/

in other words, confirming where the data is actually located could be helpful.

i'd post this to the official adobe forum, or at least do some searches over there.

Jun 25, 2022 at 02:09 PM

Slalom
Offline
• • •
Upload & Sell: On

p.1 #8 · p.1 #8 · Data/Time metadata for video files

Hmmm, Some Mainframe Computers run on UTC then have offset to give the local time.

Jun 25, 2022 at 05:30 PM

bdbits
Offline
• •
Upload & Sell: Off

p.1 #9 · p.1 #9 · Data/Time metadata for video files

If the workflow would allow invoking a command line, exiftool can rewrite video metadata as well as stills. You could probably build a command line that would adjust the video date/time metadata by whatever offsets you need, something like (untested):

exiftool -MediaCreateDate+=4:30 somefilepattern*.*

Kind of vague I know but just a seed of an idea if it can even be applied in your case and workflow.

Jun 27, 2022 at 12:01 AM


FM Forums \| Sony Forum \| Join Upload & Sell

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.