Google Takeout Migrated Photos are off by a day on the timeline

[SilleBille]

Describe the bug Photos are sorted based on UTC instead of the photo taken timezone, especially when using Google Takeout migration. As a result, this messes ordering of certain photos in the timeline, causing inconsistency between Google Photos and Memories timeline.

To Reproduce From Google Photos, use an image taken in day prior or next to UTC's current date. For example, Use a photo taken at 9PM PST -- The UTC time will be 5AM next day

Screenshots

Metadata

Timeline misordering

Platform:

• OS: All platforms
• Browser: All browsers (Tested on Firefox)
• Memories Version: 6.1.5
• Nextcloud Version: 28.0.1 RC1
• PHP Version: 8.1.26

Additional context The issue was first observed when i migrated photos from Google Takeout and applied the EXIF data. However, the photos that are captured directly from Camera and auto-uploaded don't seem to have this issue.

Sample Image and Json

Image	Json	Status
IMG_20231127_142203	IMG_20231127_142203.jpg.json	Correct
IMG_20231127_210040	IMG_20231127_210040.jpg.json	Wrong
IMG_20231127_210054	IMG_20231127_210054.jpg.json	Wrong

• Any errors in the JS console? No
• Any errors in the Nextcloud server logs? No

[pulsejet]

Please include a sample Image+JSON (the files above would be ideal)

[SilleBille]

Please include a sample Image+JSON (the files above would be ideal)

I have included the corresponding files under additional context. Thanks!