How to bring all dates to the same date?

[yegiv]

I used
exiftool -AllDates="2010:05:08 20:04:00"
to fill all the dates in the file V2004_08-05-10.3gp from its name. But when I look at digiKam, it shows 4 hours less, 16:04.
What's wrong?

Code Select Expand

A:\>exiftool -time:all -G1 -a -s V2004_08-05-10.3gp
[System]        FileModifyDate                  : 2010:05:08 17:04:00+01:00
[System]        FileAccessDate                  : 2023:12:29 18:01:57+01:00
[System]        FileCreateDate                  : 2010:05:08 17:04:00+01:00
[QuickTime]    CreateDate                      : 2010:05:08 16:04:00
[QuickTime]    ModifyDate                      : 2010:05:08 16:04:00
[Track1]        TrackCreateDate                : 0000:00:00 00:00:00
[Track1]        TrackModifyDate                : 0000:00:00 00:00:00
[Track1]        MediaCreateDate                : 0000:00:00 00:00:00
[Track1]        MediaModifyDate                : 0000:00:00 00:00:00
[Track2]        TrackCreateDate                : 0000:00:00 00:00:00
[Track2]        TrackModifyDate                : 0000:00:00 00:00:00
[Track2]        MediaCreateDate                : 0000:00:00 00:00:00
[Track2]        MediaModifyDate                : 0000:00:00 00:00:00
[UserData]      DateTimeOriginal                : 2010:05:08 16:04:00+06:00
[XMP-exif]      DateTimeOriginal                : 2010:05:08 16:04:00
[XMP-xmp]      CreateDate                      : 2010:05:08 16:04:00
[XMP-xmp]      ModifyDate                      : 2010:05:08 16:04:00

[wywh]

Use '-api QuickTimeUTC=1' in the command when dealing with movie dates.

'QuickTime' movie time stamps should be stored as UTC and programs should adjust them to the computer's time zone. '-api QuickTimeUTC=1' option converts to/from UTC to the local time zone of the computer with DST adjustment for that date. This option only affects QuickTime time stamps (QuickTime:CreateDate etc) and doesn't affect any other date/time tags (Keys:CreationDate, UserData:DateTimeOriginal, XMP, image metadata dates etc).

'-AllDates' is just a shortcut to 'DateTimeOriginal', 'CreateDate' and 'ModifyDate' in images (not so good for movies because it does not touch 'Keys:CreationDate'.

- Matti

[StarGeek]

Is that the exact command you are using?  Because the data listed shouldn't be what is set by that command.

Using that command, any tag with the name CreateDate, DateTimeOriginal, or ModifyDate should be set to exactly 2010:05:08 20:04:00.  The -api QuickTimeUTC option that wywh mentions will shift the time according to the local time zone, but according to the file system time stamps, FileCreateDate/FileModifyDate, your time zone is +01:00.  If the QuicktimeUTC option was used, then the time stamps would be 2010:05:08 21:04:00 (one hour added).

Additionally, the UserData:DateTimeOriginal includes a time zone of +06:00.  When the time zone isn't included, exiftool will add the local time zone to this tag automatically.  So it should appear as 2010:05:08 20:04:00+01:00.

Here are the results of that command on my computer, which would be in a -07:00 time zone on that day.  For the tags that were changed, they are all set to exactly 2010:05:08 20:04:00, with a -07:00 time zone added to UserData:DateTimeOriginal.

Code Select Expand

C:\>exiftool -P -overwrite_original -AllDates="2010:05:08 20:04:00" Y:\!temp\Test1.mp4
    1 image files updated

C:\>exiftool -time:all -G1 -a -s Y:\!temp\Test1.mp4
[System]        FileModifyDate                  : 2023:12:30 07:50:26-08:00
[System]        FileAccessDate                  : 2023:12:30 07:50:36-08:00
[System]        FileCreateDate                  : 2023:12:30 07:50:26-08:00
[QuickTime]     CreateDate                      : 2010:05:08 20:04:00
[QuickTime]     ModifyDate                      : 2010:05:08 20:04:00
[Track1]        TrackCreateDate                 : 0000:00:00 00:00:00
[Track1]        TrackModifyDate                 : 0000:00:00 00:00:00
[Track1]        MediaCreateDate                 : 0000:00:00 00:00:00
[Track1]        MediaModifyDate                 : 0000:00:00 00:00:00
[Track2]        TrackCreateDate                 : 0000:00:00 00:00:00
[Track2]        TrackModifyDate                 : 0000:00:00 00:00:00
[Track2]        MediaCreateDate                 : 0000:00:00 00:00:00
[Track2]        MediaModifyDate                 : 0000:00:00 00:00:00
[UserData]      DateTimeOriginal                : 2010:05:08 20:04:00-07:00
[XMP-exif]      DateTimeOriginal                : 2010:05:08 20:04:00
[XMP-xmp]       CreateDate                      : 2010:05:08 20:04:00
[XMP-xmp]       ModifyDate                      : 2010:05:08 20:04:00