Picture taken in a different timezone erroneously ends up in the previous day's folder

[nicolas-raoul]

After I go on a trip in a different timezone, I would like my pictures taken during the stay to match the days of that timezone.

Problem: For my pictures taken in Japan, consistently morning pictures are classified into the previous day's folder.

For instance, morning 10AM of January 1st is classified as December 31st of the previous year.

This is probably due either to me being in Europe, or Japan being 9 hours ahead of GMT.

Example EXIF:

ExifTool Version Number         : 12.76
File Name                       : PXL_20240101_012612027.jpg
Directory                       : /Users/nicolasraoul/lab/sortphotos/source
File Size                       : 1848 kB
File Modification Date/Time     : 2024:01:31 10:35:17+01:00
File Access Date/Time           : 2024:07:07 20:37:26+02:00
File Inode Change Date/Time     : 2024:07:06 22:59:37+02:00
File Permissions                : -rwx------
File Type                       : JPEG
File Type Extension             : jpg
MIME Type                       : image/jpeg
Exif Byte Order                 : Little-endian (Intel, II)
Make                            : Google
Camera Model Name               : Pixel 7 Pro
Orientation                     : Horizontal (normal)
X Resolution                    : 72
Y Resolution                    : 72
Resolution Unit                 : inches
Software                        : HDR+ 1.0.592726513zd
Modify Date                     : 2024:01:01 10:26:12
Y Cb Cr Positioning             : Centered
Exposure Time                   : 1/2096
F Number                        : 1.9
Exposure Program                : Program AE
ISO                             : 81
Exif Version                    : 0232
Date/Time Original              : 2024:01:01 10:26:12
Create Date                     : 2024:01:01 10:26:12
Offset Time                     : +09:00
Offset Time Original            : +09:00
Offset Time Digitized           : +09:00
Components Configuration        : Y, Cb, Cr, -
Shutter Speed Value             : 1/2091
Aperture Value                  : 1.9
Brightness Value                : 8.11
Exposure Compensation           : 0
Max Aperture Value              : 1.9
Subject Distance                : 0.238 m
Metering Mode                   : Center-weighted average
Flash                           : Off, Did not fire
Focal Length                    : 6.8 mm
Sub Sec Time                    : 027
Sub Sec Time Original           : 027
Sub Sec Time Digitized          : 027
Flashpix Version                : 0100
Color Space                     : sRGB
Exif Image Width                : 3072
Exif Image Height               : 4080
Interoperability Index          : R98 - DCF basic file (sRGB)
Interoperability Version        : 0100
Sensing Method                  : One-chip color area
Scene Type                      : Directly photographed
Custom Rendered                 : Custom
Exposure Mode                   : Auto
White Balance                   : Auto
Digital Zoom Ratio              : 0
Focal Length In 35mm Format     : 24 mm
Scene Capture Type              : Standard
Contrast                        : Normal
Saturation                      : Normal
Sharpness                       : Normal
Subject Distance Range          : Macro
Lens Make                       : Google
Lens Model                      : Pixel 7 Pro back camera 6.81mm f/1.85
Composite Image                 : Composite Image Captured While Shooting
GPS Version ID                  : 2.2.0.0
GPS Latitude Ref                : North
GPS Longitude Ref               : East
GPS Altitude Ref                : Above Sea Level
GPS Time Stamp                  : 01:26:10
GPS Img Direction Ref           : Magnetic North
GPS Img Direction               : 35
GPS Date Stamp                  : 2024:01:01
Compression                     : JPEG (old-style)
Thumbnail Offset                : 1315
Thumbnail Length                : 18131
JFIF Version                    : 1.02
Profile CMM Type                : 
Profile Version                 : 4.0.0
Profile Class                   : Display Device Profile
Color Space Data                : RGB
Profile Connection Space        : XYZ
Profile Date Time               : 2023:03:09 10:57:00
Profile File Signature          : acsp
Primary Platform                : Unknown ()
CMM Flags                       : Not Embedded, Independent
Device Manufacturer             : Google
Device Model                    : 
Device Attributes               : Reflective, Glossy, Positive, Color
Rendering Intent                : Perceptual
Connection Space Illuminant     : 0.9642 1 0.82491
Profile Creator                 : Google
Profile ID                      : 61473528d5aaa311e143dfc93efaa268
Profile Description             : sRGB IEC61966-2.1
Profile Copyright               : Copyright (c) 2023 Google Inc.
Media White Point               : 0.9642 1 0.82491
Media Black Point               : 0 0 0
Red Matrix Column               : 0.43604 0.22249 0.01392
Green Matrix Column             : 0.38512 0.7169 0.09706
Blue Matrix Column              : 0.14305 0.06061 0.71391
Red Tone Reproduction Curve     : (Binary data 32 bytes, use -b option to extract)
Chromatic Adaptation            : 1.04788 0.02292 -0.05019 0.02959 0.99048 -0.01704 -0.00922 0.01508 0.75168
Blue Tone Reproduction Curve    : (Binary data 32 bytes, use -b option to extract)
Green Tone Reproduction Curve   : (Binary data 32 bytes, use -b option to extract)
XMP Toolkit                     : Adobe XMP Core 5.1.0-jc003
Version                         : 1.0
Has Extended XMP                : FCD6E62407139F075DE35B55C9530F3E
Directory Item Mime             : image/jpeg
Directory Item Semantic         : Primary
Directory Item Length           : 75414
MPF Version                     : 0100
Number Of Images                : 2
MP Image Flags                  : (none)
MP Image Format                 : JPEG
MP Image Type                   : Undefined
MP Image Length                 : 75414
MP Image Start                  : 1772448
Dependent Image 1 Entry Number  : 0
Dependent Image 2 Entry Number  : 0
Image Width                     : 3072
Image Height                    : 4080
Encoding Process                : Baseline DCT, Huffman coding
Bits Per Sample                 : 8
Color Components                : 3
Y Cb Cr Sub Sampling            : YCbCr4:2:0 (2 2)
Hdr Plus Makernote              : (Binary data 75981 bytes, use -b option to extract)
Aperture                        : 1.9
Image Size                      : 3072x4080
Megapixels                      : 12.5
Scale Factor To 35 mm Equivalent: 3.5
Shutter Speed                   : 1/2096
Create Date                     : 2024:01:01 10:26:12.027+09:00
Date/Time Original              : 2024:01:01 10:26:12.027+09:00
Modify Date                     : 2024:01:01 10:26:12.027+09:00
Thumbnail Image                 : (Binary data 18131 bytes, use -b option to extract)
GPS Altitude                    : 534.2 m Above Sea Level
GPS Date/Time                   : 2024:01:01 01:26:10Z
GPS Latitude                    : 37 deg 51' 53.83" N
GPS Longitude                   : 140 deg 13' 55.42" E
MP Image 2                      : (Binary data 75414 bytes, use -b option to extract)
Circle Of Confusion             : 0.009 mm
Depth Of Field                  : 0.04 m (0.22 - 0.26 m)
Field Of View                   : 73.7 deg
Focal Length                    : 6.8 mm (35 mm equivalent: 24.0 mm)
GPS Position                    : 37 deg 51' 53.83" N, 140 deg 13' 55.42" E
Hyperfocal Distance             : 2.94 m
Light Value                     : 13.1
Lens ID                         : Pixel 7 Pro back camera 6.81mm f/1.85

Note the two different lines Create Date : 2024:01:01 10:26:12 and Create Date : 2024:01:01 10:26:12.027+09:00, maybe that matters.