ExifTool Forum

ExifTool => The "exiftool" Application => Topic started by: homeserver on January 31, 2024, 04:10:48 AM

Title: crappy actioncam timezone editing
Post by: homeserver on January 31, 2024, 04:10:48 AM
I need to set createdate from filemodifydate so I did
exiftool '-createdate<filemodifydate' namefile.MOV

it work ... but
what I need is
Create Date                    : 2023:06:24 18:14:04
what I get
Create Date                    : 2023:06:24 18:14:04+02:00

When I sort it, the software I use set the date
2023:06:24 20:14:04

that is wrong.
Can anyone write the right command? I've tried to study and I make a lot of test but I'm not enought skilled.
Thank's
Title: Re: crappy actioncam timezone editing
Post by: wywh on January 31, 2024, 08:17:43 AM
Use QuickTimeUTC option with movies. So try something like this...

exiftool -m -P -overwrite_original -wm w -api LargeFileSupport=1 -api QuickTimeUTC=1 '-AllDates<FileModifyDate' '-Track*Date<FileModifyDate' '-Media*Date<FileModifyDate' '-Keys:CreationDate<FileModifyDate' '-FileCreateDate<FileModifyDate' movie.mov
...and check the results with:

exiftool -a -G1 -s -api LargeFileSupport=1 -api QuickTimeUTC=1 -FileCreateDate -Time:All movie.mov
- Matti
Title: Re: crappy actioncam timezone editing
Post by: StarGeek on January 31, 2024, 11:26:58 AM
Quote from: homeserver on January 31, 2024, 04:10:48 AMWhen I sort it, the software I use set the date
2023:06:24 20:14:04

that is wrong.

It's actually correct.  Video time stamps are supposed to be UTC and "2023:06:24 20:14:04+02:00" in UTC is "2023:06:24 18:14:04".

My standard copy/paste regarding video time stamps

Most video time stamps are supposed to be set to UTC and programs that read it are supposed to adjust this to the local time zone when displayed (see 5th paragraph on the Quicktime tags page (https://exiftool.org/TagNames/QuickTime.html)), with the most common exceptions being the Quicktime:CreationDate (not to be confused with the Quicktime:CreateDate) and the Quicktime:DateTimeOriginal.

If your computer is in the same time zone as where the video was shot, ignoring differences for Daylight/Summer time, then you can add the -api QuickTimeUTC option (https://exiftool.org/ExifTool.html#QuickTimeUTC) and exiftool will automatically adjust the time to/from UTC when writing/reading.  Otherwise, you either have to figure out the UTC yourself or use this -api option and include the correct time zone, e.g. "2023:02:03 04:05:06±07:00".

Title: Re: crappy actioncam timezone editing
Post by: homeserver on February 07, 2024, 11:58:43 AM
Sorry for longtime reply, thanks for help.
Not really what I need but very close.
(maybe what I'm wondering is simply not possible) :D
Title: Re: crappy actioncam timezone editing
Post by: StarGeek on February 07, 2024, 02:07:47 PM
Quote from: homeserver on February 07, 2024, 11:58:43 AM(maybe what I'm wondering is simply not possible) :D

The Quicktime:CreateDate tag is in UTC.  It will always be YYYY:MM:DD HH:mm:ss. It cannot hold anything else like a time zone.