Unexpected MacOS:MDItemContentCreationDate Offset Value

[Cici]

Hi, I used a CSV with MSG tags to update date/time/offset values in my DNG, TIF and JPG files. The value in my CSV was 1961:02:12 12:00:00-05:00. And all date/time/offset results were either 1961:02:12 12:00:00-05:00 or 1961:02:12 17:00:00Z. All good so far. However, the MacOS:MDItemContentCreationDate and MacOS:MDItemContentModificationDate Offset value returned 1961:02:12 12:00:00-08:00. -05:00 is EST and the GPS Date/Time and GPS coordinates are east coast as well. I need the MacOS:MDItemContentCreationDate offset value to be correct. Any idea why this is happening and how to correct it? Thanks.
(MacOS Sonoma 14.6.1, ExifTool 12.95)

[Cici]

I think I have figured it out. I viewed the metadata for an image taken with my iPhone. It appears that the MacOS:MDItemContentCreationDate and the MacOS:MDItemContentModificationDate offset values change according to one's current location. So if the SubSecDateTimeOriginal value is 2024:05:26 15:02:59.366-04:00, i.e. EDT, but you are currently on the west coast, then the MacOS:MDItemContentCreationDate and the MacOS:MDItemContentModificationDate offset values will be -07:00, i.e. 2024:05:26 15:02:59.366-07:00. If the SubSecDateTimeOriginal Offset were -05:00, i.e. EST, and you view the file on the west coast, then the MacOS:MDItemContentCreationDate Offset value would be -08:00.

For images, I believe the FileCreateDate derives from the MDItemContentCreationDate. And of course the file system dates/times always report according to one's current time zone rather than according to the date/time where the image was taken. Note: The MacOS Finder "Created Date" Attribute derives from the MacOS:MDItemContentCreationDate value. Also note: My image includes accurate GPS information and Apple Photos displays the date/time when the photo was actually taken, regardless of one's current location.

[MacOS]         FileCreateDate                  : 2024:05:26 12:02:59-07:00 (12pm PDT)
[MacOS]         MDItemContentCreationDate       : 2024:05:26 15:02:59-07:00 (3pm PDT)
[Composite]     SubSecDateTimeOriginal          : 2024:05:26 15:02:59.366-04:00 (3pm EDT)