2 Messages
•
92 Points
Tue, May 17, 2016 9:00 PM
Not a problem
Lightroom Classic: MP4 Creation Date always 66 years off
I have some video files (mp4) created with a Samsung Android phone. When I import into Lightroom on MacOS, the creation time is imported with a date exactly 66 years too early. That is, a real date of 2012 would appear as 1946.
This is almost certainly a bug in translating the MP4 epoch of Jan 1, 1904 to the Mac (unix) epoch of Jan 1, 1970.
Here is a link to a short video.
http://vantcm.com/20120414_155709.mp4
This is almost certainly a bug in translating the MP4 epoch of Jan 1, 1904 to the Mac (unix) epoch of Jan 1, 1970.
Here is a link to a short video.
http://vantcm.com/20120414_155709.mp4
Problems
•
Updated
a year ago
53
13
Helpful Widget
How can we improve?
Tags
No tags available
Responses
Victoria_Bampton_Lightroom_Queen
Champion
•
6.1K Messages
•
106.1K Points
5 years ago
Victoria Bampton a.k.a. The Lightroom Queen
www.lightroomqueen.com
Author of Adobe Lightroom Classic - The Missing FAQ and Adobe Lightroom - Edit Like a Pro books.
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
5 years ago
A quick search yields this explanation: http://u88.n24.queensu.ca/exiftool/forum/index.php/topic,6884.msg34566.html#msg34566. The phone application is using the 1970 epoch rather than 1904 as required by the standard. You should file a bug report with Samsung.
0
ray_cathcart
2 Messages
•
92 Points
5 years ago
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
5 years ago
0
0
4wk
11 Messages
•
188 Points
3 years ago
Hello there,
I'm pretty new to Lightroom Classic, but I migh have a problem about the "Capture Date" of some of my videos.
With my good old HTC Sensation smartphone, I took in 2012 some photos and videos of the XX's concert. And I have really strange metadata in Lightroom, for 2 media shot at the same date.
I've put 2 screenshots to be as clear as I could be.
1 - The video
----
2 - The photo
----
As you can see, for the video we have:
For the photo, we have:
Here are my questions:
Thank you so much for your time,
Cheers.
0
0
4wk
11 Messages
•
188 Points
3 years ago
Thank you for this investigation John.
For the record, I don't have 1 video with this problem, but 11, all recorded with the old HTC Sensation but not at the same date. All of them have the year 1946, but not the same day/month.
1. I'm pretty sure windows have nothing to do with it. It might be a smartphone bug (but if it was, why the information of windows is correct?), or a misinterpretation of Lightroom. Here are the uploads you asked for:
- Video: https://www.dropbox.com/s/7zfbygyx1hy3pvg/VIDEO0002.mp4?dl=0
- Photo: https://www.dropbox.com/s/c723b9sjibs9qg9/IMAG0105.jpg?dl=0
2. I lived in Paris. My computer have "Set time automatically" at "On" but "Set time zone automatically" at "Off", and the Time zone is "UTC +01:00 Brussels, Madrid, Paris"
3. The concert was in Paris, so same timezone ;)
Note: This conversation was created from a reply on: Lightroom Classic: Incorrect year-only Capture Date for videos (1946).
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
3 years ago
The easiest way to work around this is to use LR's Metadata > Edit Capture Time to change the year. You can select all 11 videos and do them in batch.
Since the phone is so "old", there's no point in submitting a bug report to the manufacturer. (Not that they'd pay much attention to bug reports -- who does these days?)
0
0
4wk
11 Messages
•
188 Points
3 years ago
Could you give me a formula to calculate the year I have to put in the Capture Time? Because for this video I can put 2012 but for the other I don't have a picture to tell me the year :/
Could you please confirm/answer question 1 and 3 for my general knowledge? ;)
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
3 years ago
ExifTool shows the video has a QuickTime:CreateDate time of 19:22:
and the photo has an EXIF:DateTimeOriginal time of 21:20:
This makes sense. QuickTime:CreateDate is supposed to be recorded in UTC (which most smartphones do, but many cameras do not), and EXIF:DateTimeOriginal is supposed to be recorded local time. Paris local time is UTC+1 in the winter and UTC+2 in the summer (through the last Sunday in October), and indeed the time recorded in the photo is 2 hours later than that recorded in the video.
I can't authoritatively explain a Windows Date Modified of 22:20 -- too many unknowns. The date-modified field is set by Windows whenever any software modifies the file. While the Windows NTFS file system stores date/times in UTC (and displays them in local time), I'm not sure how the Android file system in the phone stores date/times. To further confuse things, the ancient PICT protocol that is often used to transfer photos and videos from devices to computers via USB cable seems to get time zones confused (or at least, many implementations of the protocol do). It's entirely likely that somewhere in the path from the phone to your computer, so component garbled a time zone adjustment.
But in general, I wouldn't worry about file-system Date Modified and Date Created. They're too fragile, liable to get changed by random software apps, including many backup/restore utilities. (This is as true on Mac as on Windows, to the chagrin of long-time Mac users.)
The photo industry has solid standards for storing date/times in metadata inside photos, and I rely on those and applications like LR that I can trust (more or less). Video has standards (QuickTime/MP4), but they're badly written with respect to date/time, and the industry has layered lots of mess on top of the bad standard.
1
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
3 years ago
All the photos will be off by 66 years (time 0 of 1970 instead of 1904). So you could add 66 years to all of the dates. But an easier way is to select all 11 photos and then most-select (click) the one you know for sure (1946). Then do Metadata > Edit Capture Time, change the year from 1946 to 2012, and click Change All. The dates of all the other photos will be shifted by the same relative amount (66 years). (When you're select photos, the Edit Capture TIme explains that shifting, but when you've selected videos, it doesn't for some reason.)
0
0
4wk
11 Messages
•
188 Points
3 years ago
31/12/1969 => and I can't do +66 years, because we are not at the year 2035 :D
This one is not a big deal for me, so I can even delete it; but are you interested in checking it? I can upload it as well.
3
0
autumn_eden
6 Messages
•
112 Points
a year ago
1) On the absolutely latest version of Lightroom CC Classic (8.4 Release with ACR of 11.4 - 201908011719-03751b60)
2) This is clearly a bug with Lightroom, because other video apps detect the date properly
1
0
geoff_faulkner_6626869
57 Messages
•
860 Points
a year ago
3
0