I was trying to figure a way to sort a bunch of MOVs and JPGs by the time that they were taken. The "Date Taken" column doesn't work because the this value is empty for MOV files. Don't know if that's true for other video formats like MP4s, will test that. Anyway I found that "Content Created" column seems to work for this purpose, as values for this column are shown for both MOVs and JPGs. "Media Created" doesn't work.
I do notice that for some files "Content Created" is one hour behind "Date Taken". I thought maybe one of these property values adjusts for daylight savings time and the other doesn't? But then the different values for these two columns seems to appear during the winter months when DST is NOT in force, and the values are the same during the summer months when DST is in force. So that is a bit odd.
sort MOVs and JPGs together by creation time
Re: sort MOVs and JPGs together by creation time
Everything stores dates as FILETIMEs internally.
A FILETIME is the number of 100-nanoseconds since January 1, 1601 in UTC.
Everything will show the dates adjusted to your local time with any day light saving offset.
The issue is most likely caused by the hardware saving the date taken/content created timestamp.
The hardware will most likely not use a daylight savings offset when converting to UTC.
Everything uses the system to gather content created (System.Document.DateCreated)
This appears to just be the date modified or the date created (whichever is earliest).
A FILETIME is the number of 100-nanoseconds since January 1, 1601 in UTC.
Everything will show the dates adjusted to your local time with any day light saving offset.
The issue is most likely caused by the hardware saving the date taken/content created timestamp.
The hardware will most likely not use a daylight savings offset when converting to UTC.
Everything uses the system to gather content created (System.Document.DateCreated)
This appears to just be the date modified or the date created (whichever is earliest).