crappy actioncam timezone editing

Started by homeserver, January 31, 2024, 04:10:48 AM

Previous topic - Next topic

homeserver

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

wywh

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

StarGeek

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), 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 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".

"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

homeserver

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

StarGeek

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.
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype