Hi,
I've really tried but just can't figure this out!
I've got some videos I took in Thailand this year, and I'm trying to get them in UTC format as currently they're not correct.
For instance, the Composite -> Create Date is '2024:05:23 13:25:34+07:00', but the File Creation Date/Time is '2024:05:23 14:25:34+01:00'. Is there a good way to copy the Composite's time and time zone offset over?
Thank you so much in advance! I've attached the readout below.
My current time zone is UTC+0 if that helps.
[ExifTool] ExifToolVersion : 13.11
[System] FileName : XT3A0059.MOV
[System] Directory : C:/Users/alexm/OneDrive - University of Surrey/Pictures/Camera imports/World Travels 2023-24/Video/SOOC
[System] FileSize : 468 MB
[System] FileModifyDate : 2024:05:23 14:25:34+01:00
[System] FileAccessDate : 2025:01:14 12:05:27+00:00
[System] FileCreateDate : 2024:05:23 14:25:34+01:00
[System] FilePermissions : -rw-rw-rw-
[File] FileType : MOV
[File] FileTypeExtension : mov
[File] MIMEType : video/quicktime
[QuickTime] MajorBrand : Apple QuickTime (.MOV/QT)
[QuickTime] MinorVersion : 0.0.0
[QuickTime] CompatibleBrands : qt
[QuickTime] MovieHeaderVersion : 0
[QuickTime] CreateDate : 2024:05:23 13:25:34
[QuickTime] ModifyDate : 2024:05:23 07:26:16
[QuickTime] TimeScale : 30000
[QuickTime] Duration : 18.02 s
[QuickTime] PreferredRate : 1
[QuickTime] PreferredVolume : 100.00%
[QuickTime] MatrixStructure : 1 0 0 0 1 0 0 0 1
[QuickTime] PreviewTime : 0 s
[QuickTime] PreviewDuration : 0 s
[QuickTime] PosterTime : 0 s
[QuickTime] SelectionTime : 0 s
[QuickTime] SelectionDuration : 0 s
[QuickTime] CurrentTime : 0 s
[QuickTime] NextTrackID : 4
[QuickTime] MediaDataSize : 462375424
[QuickTime] MediaDataOffset : 5460278
[Track1] TrackHeaderVersion : 0
[Track1] TrackCreateDate : 2024:05:23 06:26:16
[Track1] TrackModifyDate : 2024:05:23 06:26:16
[Track1] TrackID : 1
[Track1] TrackDuration : 18.02 s
[Track1] TrackLayer : 0
[Track1] TrackVolume : 0.00%
[Track1] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track1] ImageWidth : 3840
[Track1] ImageHeight : 2160
[Track1] TimeCode : 3
[Track1] MediaHeaderVersion : 0
[Track1] MediaCreateDate : 2024:05:23 06:26:16
[Track1] MediaModifyDate : 2024:05:23 06:26:16
[Track1] MediaTimeScale : 30000
[Track1] MediaDuration : 18.02 s
[Track1] HandlerClass : Media Handler
[Track1] HandlerType : Video Track
[Track1] GraphicsMode : srcCopy
[Track1] OpColor : 0 0 0
[Track1] CompressorID : hvc1
[Track1] SourceImageWidth : 3840
[Track1] SourceImageHeight : 2160
[Track1] XResolution : 72
[Track1] YResolution : 72
[Track1] BitDepth : 24
[Track1] ColorProfiles : nclc
[Track1] ColorPrimaries : BT.709
[Track1] TransferCharacteristics : BT.601
[Track1] MatrixCoefficients : BT.601
[Track1] VideoFrameRate : 29.97
[Track2] TrackHeaderVersion : 0
[Track2] TrackCreateDate : 2024:05:23 06:26:16
[Track2] TrackModifyDate : 2024:05:23 06:26:16
[Track2] TrackID : 2
[Track2] TrackDuration : 18.02 s
[Track2] TrackLayer : 0
[Track2] TrackVolume : 100.00%
[Track2] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track2] TimeCode : 3
[Track2] MediaHeaderVersion : 0
[Track2] MediaCreateDate : 2024:05:23 06:26:16
[Track2] MediaModifyDate : 2024:05:23 06:26:16
[Track2] MediaTimeScale : 48000
[Track2] MediaDuration : 18.02 s
[Track2] HandlerClass : Media Handler
[Track2] HandlerType : Audio Track
[Track2] Balance : 0
[Track2] AudioFormat : lpcm
[Track2] AudioChannels : 3
[Track2] AudioBitsPerSample : 16
[Track2] AudioSampleRate : 1
[Track3] TrackHeaderVersion : 0
[Track3] TrackCreateDate : 2024:05:23 06:26:16
[Track3] TrackModifyDate : 2024:05:23 06:26:16
[Track3] TrackID : 3
[Track3] TrackDuration : 18.02 s
[Track3] TrackLayer : 0
[Track3] TrackVolume : 0.00%
[Track3] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track3] MediaHeaderVersion : 0
[Track3] MediaCreateDate : 2024:05:23 06:26:16
[Track3] MediaModifyDate : 2024:05:23 06:26:16
[Track3] MediaTimeScale : 30000
[Track3] MediaDuration : 18.02 s
[Track3] HandlerClass : Media Handler
[Track3] HandlerType : Time Code
[Track3] GenMediaVersion : 0
[Track3] GenFlags : 0 0 0
[Track3] GenGraphicsMode : ditherCopy
[Track3] GenOpColor : 32768 32768 32768
[Track3] GenBalance : 0
[Track3] TextFont : System
[Track3] TextFace : Plain
[Track3] TextSize : 12
[Track3] TextColor : 0 0 0
[Track3] BackgroundColor : 0 0 0
[Track3] FontName :
[Track3] OtherFormat : tmcd
[Track3] PlaybackFrameRate : 29.97002997
[UserData] Format : Digital Camera
[UserData] Information : FUJIFILM DIGITAL CAMERA X-T3
[FujiFilm] MovieStreamName : FUJIFILM MOV STREAM 0130
[FujiFilm] Version : 0130
[FujiFilm] InternalSerialNumber : FF02B6646333 Y56741 2021:11:09 DC1370216C3D
[FujiFilm] Quality : NORMAL
[FujiFilm] Sharpness : 0 (normal)
[FujiFilm] WhiteBalance : Auto
[FujiFilm] Saturation : 0 (normal)
[FujiFilm] NoiseReduction : 0 (normal)
[FujiFilm] FujiFlashMode : Not Attached
[FujiFilm] FlashExposureComp : 0
[FujiFilm] FocusMode : Movie
[FujiFilm] SlowSync : Off
[FujiFilm] PictureMode : Manual
[FujiFilm] ShadowTone : 0 (normal)
[FujiFilm] HighlightTone : 0 (normal)
[FujiFilm] GrainEffectRoughness : Off
[FujiFilm] AutoBracketing : Off
[FujiFilm] BlurWarning : None
[FujiFilm] FocusWarning : Good
[FujiFilm] ExposureWarning : Good
[FujiFilm] FilmMode : F0/Standard (Provia)
[FujiFilm] MinFocalLength : 16
[FujiFilm] MaxFocalLength : 80
[FujiFilm] MaxApertureAtMinFocal : 4
[FujiFilm] MaxApertureAtMaxFocal : 4
[FujiFilm] VideoRecordingMode : F-log
[FujiFilm] PeripheralLighting : On
[FujiFilm] VideoCompression : Log GOP
[FujiFilm] FrameRate : 30
[FujiFilm] FrameWidth : 3840
[FujiFilm] FrameHeight : 2160
[FujiFilm] FullHDHighSpeedRec : Off
[IFD0] Make : FUJIFILM
[IFD0] Model : X-T3
[IFD0] ModifyDate : 2024:05:23 07:26:16
[IFD0] Artist : Alex McDermott
[IFD0] ThumbnailOffset : 5393622
[IFD0] ThumbnailLength : 8656
[IFD0] Copyright : Alex McDermott
[IFD0] ThumbnailImage : (Binary data 8656 bytes, use -b option to extract)
[ExifIFD] ExposureTime : 1/60
[ExifIFD] FNumber : 5.0
[ExifIFD] ISO : 640
[ExifIFD] SensitivityType : Standard Output Sensitivity
[ExifIFD] DateTimeOriginal : 2024:05:23 13:25:34
[ExifIFD] CreateDate : 2024:05:23 13:25:34
[ExifIFD] OffsetTime : +07:00
[ExifIFD] OffsetTimeOriginal : +07:00
[ExifIFD] OffsetTimeDigitized : +07:00
[ExifIFD] ShutterSpeedValue : 1/60
[ExifIFD] ExposureCompensation : 0
[ExifIFD] MeteringMode : Multi-segment
[ExifIFD] LensInfo : 16-80mm f/4
[XMP-x] XMPToolkit : Image::ExifTool 13.11
[XMP-xmp] CreateDate : 2024:05:23 13:25:34
[XMP-xmp] ModifyDate : 2024:05:23 07:26:16
[Composite] Aperture : 5.0
[Composite] ImageSize : 3840x2160
[Composite] Megapixels : 8.3
[Composite] ShutterSpeed : 1/60
[Composite] SubSecCreateDate : 2024:05:23 13:25:34+07:00
[Composite] SubSecDateTimeOriginal : 2024:05:23 13:25:34+07:00
[Composite] SubSecModifyDate : 2024:05:23 07:26:16+07:00
[Composite] AvgBitrate : 205 Mbps
[Composite] Rotation : 0
[Composite] LightValue : 7.9
I think you want to do this:
exiftool "-filecreatedate<subseccreatedate" FILE
The "[Composite] Create Date" description refers to the Composite:SubSecCreateDate tag. And when you read back the FileCreateDate, the time will be displayed in the system time zone.
- Phil
Quote from: Phil Harvey on January 14, 2025, 08:21:40 AMAnd when you read back the FileCreateDate, the time will be displayed in the system time zone.
Which means the
2024:05:23 13:25:34+07:00 time stamp will show up as
2024:05:23 07:25:34+01:00.
The time stamps in this file are sort of weird. The
Track*Date/
Media*Date tags are correct at
2024:05:23 06:26:16, because they are supposed to be set to UTC. But the
Quicktime:CreateDate/
Quicktime:ModifyDate, which are also supposed to be UTC, are different.
Thank you both so much for responding!
I ran the command and it's changed the FileCreateDate, but oddly still in the wrong time zone of UTC+1. It's reading '2024:05:23 07:25:34+01:00' instead of '2024:05:23 13:25:34+07:00' (or should it be 2024:05:23 06:25:34+07:00?).
Just to clarify, the shot was taken at 13:25 in UTC+7, or 06:25 in UTC+0 (where I am currently).
Is there a better tag to copy from, such as [ExifIFD] CreateDate and OffsetTime?
Really appreciate the help, sorry for the confusion.
EDIT: The Quicktime:CreateDate/Quicktime:ModifyDate times are not UTC but I have been messing around with file trying to get this to work, but the other videos in the folder are all correct at UTC time. I tried the same code that Phil has suggested on another file and the result is the same.
[ExifTool] ExifToolVersion : 13.11
[System] FileName : XT3A0059.MOV
[System] Directory : C:/Users/alexm/OneDrive - University of Surrey/Pictures/Camera imports/World Travels 2023-24/Video/SOOC
[System] FileSize : 468 MB
[System] FileModifyDate : 2024:05:23 14:25:34+01:00
[System] FileAccessDate : 2025:01:14 15:21:18+00:00
[System] FileCreateDate : 2024:05:23 07:25:34+01:00
[System] FilePermissions : -rw-rw-rw-
[File] FileType : MOV
[File] FileTypeExtension : mov
[File] MIMEType : video/quicktime
[QuickTime] MajorBrand : Apple QuickTime (.MOV/QT)
[QuickTime] MinorVersion : 0.0.0
[QuickTime] CompatibleBrands : qt
[QuickTime] MovieHeaderVersion : 0
[QuickTime] CreateDate : 2024:05:23 13:25:34
[QuickTime] ModifyDate : 2024:05:23 07:26:16
[QuickTime] TimeScale : 30000
[QuickTime] Duration : 18.02 s
[QuickTime] PreferredRate : 1
[QuickTime] PreferredVolume : 100.00%
[QuickTime] MatrixStructure : 1 0 0 0 1 0 0 0 1
[QuickTime] PreviewTime : 0 s
[QuickTime] PreviewDuration : 0 s
[QuickTime] PosterTime : 0 s
[QuickTime] SelectionTime : 0 s
[QuickTime] SelectionDuration : 0 s
[QuickTime] CurrentTime : 0 s
[QuickTime] NextTrackID : 4
[QuickTime] MediaDataSize : 462375424
[QuickTime] MediaDataOffset : 5460278
[Track1] TrackHeaderVersion : 0
[Track1] TrackCreateDate : 2024:05:23 06:26:16
[Track1] TrackModifyDate : 2024:05:23 06:26:16
[Track1] TrackID : 1
[Track1] TrackDuration : 18.02 s
[Track1] TrackLayer : 0
[Track1] TrackVolume : 0.00%
[Track1] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track1] ImageWidth : 3840
[Track1] ImageHeight : 2160
[Track1] TimeCode : 3
[Track1] MediaHeaderVersion : 0
[Track1] MediaCreateDate : 2024:05:23 06:26:16
[Track1] MediaModifyDate : 2024:05:23 06:26:16
[Track1] MediaTimeScale : 30000
[Track1] MediaDuration : 18.02 s
[Track1] HandlerClass : Media Handler
[Track1] HandlerType : Video Track
[Track1] GraphicsMode : srcCopy
[Track1] OpColor : 0 0 0
[Track1] CompressorID : hvc1
[Track1] SourceImageWidth : 3840
[Track1] SourceImageHeight : 2160
[Track1] XResolution : 72
[Track1] YResolution : 72
[Track1] BitDepth : 24
[Track1] ColorProfiles : nclc
[Track1] ColorPrimaries : BT.709
[Track1] TransferCharacteristics : BT.601
[Track1] MatrixCoefficients : BT.601
[Track1] VideoFrameRate : 29.97
[Track2] TrackHeaderVersion : 0
[Track2] TrackCreateDate : 2024:05:23 06:26:16
[Track2] TrackModifyDate : 2024:05:23 06:26:16
[Track2] TrackID : 2
[Track2] TrackDuration : 18.02 s
[Track2] TrackLayer : 0
[Track2] TrackVolume : 100.00%
[Track2] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track2] TimeCode : 3
[Track2] MediaHeaderVersion : 0
[Track2] MediaCreateDate : 2024:05:23 06:26:16
[Track2] MediaModifyDate : 2024:05:23 06:26:16
[Track2] MediaTimeScale : 48000
[Track2] MediaDuration : 18.02 s
[Track2] HandlerClass : Media Handler
[Track2] HandlerType : Audio Track
[Track2] Balance : 0
[Track2] AudioFormat : lpcm
[Track2] AudioChannels : 3
[Track2] AudioBitsPerSample : 16
[Track2] AudioSampleRate : 1
[Track3] TrackHeaderVersion : 0
[Track3] TrackCreateDate : 2024:05:23 06:26:16
[Track3] TrackModifyDate : 2024:05:23 06:26:16
[Track3] TrackID : 3
[Track3] TrackDuration : 18.02 s
[Track3] TrackLayer : 0
[Track3] TrackVolume : 0.00%
[Track3] MatrixStructure : 1 0 0 0 1 0 0 0 1
[Track3] MediaHeaderVersion : 0
[Track3] MediaCreateDate : 2024:05:23 06:26:16
[Track3] MediaModifyDate : 2024:05:23 06:26:16
[Track3] MediaTimeScale : 30000
[Track3] MediaDuration : 18.02 s
[Track3] HandlerClass : Media Handler
[Track3] HandlerType : Time Code
[Track3] GenMediaVersion : 0
[Track3] GenFlags : 0 0 0
[Track3] GenGraphicsMode : ditherCopy
[Track3] GenOpColor : 32768 32768 32768
[Track3] GenBalance : 0
[Track3] TextFont : System
[Track3] TextFace : Plain
[Track3] TextSize : 12
[Track3] TextColor : 0 0 0
[Track3] BackgroundColor : 0 0 0
[Track3] FontName :
[Track3] OtherFormat : tmcd
[Track3] PlaybackFrameRate : 29.97002997
[UserData] Format : Digital Camera
[UserData] Information : FUJIFILM DIGITAL CAMERA X-T3
[FujiFilm] MovieStreamName : FUJIFILM MOV STREAM 0130
[FujiFilm] Version : 0130
[FujiFilm] InternalSerialNumber : FF02B6646333 Y56741 2021:11:09 DC1370216C3D
[FujiFilm] Quality : NORMAL
[FujiFilm] Sharpness : 0 (normal)
[FujiFilm] WhiteBalance : Auto
[FujiFilm] Saturation : 0 (normal)
[FujiFilm] NoiseReduction : 0 (normal)
[FujiFilm] FujiFlashMode : Not Attached
[FujiFilm] FlashExposureComp : 0
[FujiFilm] FocusMode : Movie
[FujiFilm] SlowSync : Off
[FujiFilm] PictureMode : Manual
[FujiFilm] ShadowTone : 0 (normal)
[FujiFilm] HighlightTone : 0 (normal)
[FujiFilm] GrainEffectRoughness : Off
[FujiFilm] AutoBracketing : Off
[FujiFilm] BlurWarning : None
[FujiFilm] FocusWarning : Good
[FujiFilm] ExposureWarning : Good
[FujiFilm] FilmMode : F0/Standard (Provia)
[FujiFilm] MinFocalLength : 16
[FujiFilm] MaxFocalLength : 80
[FujiFilm] MaxApertureAtMinFocal : 4
[FujiFilm] MaxApertureAtMaxFocal : 4
[FujiFilm] VideoRecordingMode : F-log
[FujiFilm] PeripheralLighting : On
[FujiFilm] VideoCompression : Log GOP
[FujiFilm] FrameRate : 30
[FujiFilm] FrameWidth : 3840
[FujiFilm] FrameHeight : 2160
[FujiFilm] FullHDHighSpeedRec : Off
[IFD0] Make : FUJIFILM
[IFD0] Model : X-T3
[IFD0] ModifyDate : 2024:05:23 07:26:16
[IFD0] Artist : Alex McDermott
[IFD0] ThumbnailOffset : 5393622
[IFD0] ThumbnailLength : 8656
[IFD0] Copyright : Alex McDermott
[IFD0] ThumbnailImage : (Binary data 8656 bytes, use -b option to extract)
[ExifIFD] ExposureTime : 1/60
[ExifIFD] FNumber : 5.0
[ExifIFD] ISO : 640
[ExifIFD] SensitivityType : Standard Output Sensitivity
[ExifIFD] DateTimeOriginal : 2024:05:23 13:25:34
[ExifIFD] CreateDate : 2024:05:23 13:25:34
[ExifIFD] OffsetTime : +07:00
[ExifIFD] OffsetTimeOriginal : +07:00
[ExifIFD] OffsetTimeDigitized : +07:00
[ExifIFD] ShutterSpeedValue : 1/60
[ExifIFD] ExposureCompensation : 0
[ExifIFD] MeteringMode : Multi-segment
[ExifIFD] LensInfo : 16-80mm f/4
[XMP-x] XMPToolkit : Image::ExifTool 13.11
[XMP-xmp] CreateDate : 2024:05:23 13:25:34
[XMP-xmp] ModifyDate : 2024:05:23 07:26:16
[Composite] Aperture : 5.0
[Composite] ImageSize : 3840x2160
[Composite] Megapixels : 8.3
[Composite] ShutterSpeed : 1/60
[Composite] SubSecCreateDate : 2024:05:23 13:25:34+07:00
[Composite] SubSecDateTimeOriginal : 2024:05:23 13:25:34+07:00
[Composite] SubSecModifyDate : 2024:05:23 07:26:16+07:00
[Composite] AvgBitrate : 205 Mbps
[Composite] Rotation : 0
[Composite] LightValue : 7.9
Quote from: AlexMcDermott on January 14, 2025, 10:42:42 AMI ran the command and it's changed the FileCreateDate, but oddly still in the wrong time zone of UTC+1.
I suggest you re-read both of our previous responses.
- Phil
Quote from: AlexMcDermott on January 14, 2025, 10:42:42 AMJust to clarify, the shot was taken at 13:25 in UTC+7, or 06:25 in UTC+0 (where I am currently).
Ok, I think there might be a misunderstanding of time zones here. If the time is 13:25 UTC then +07:00 for the time zone, then the local time would have been
2024:05:23 20:25:34+07:00. This is the value that would have been in the EXIF time stamps and
2024:05:23 13:25:34 should be the value in all the UTC tags. Time zones are not added to the time stamp.
If the local time was
2024:05:23 13:25:34+07:00 then UTC would have been
2024:05:23 06:26:16 because UTC is +00:00 time zone. And the file system time stamps would show up as
2024:05:23 07:25:34+01:00 because of Summer/Daylight savings time. These values are correctly reflected in the
FileCreateDate, the
Track*Date/
Media*Date, and the the
EXIF:DateTimeOriginal/
EXIF:CreateDate/
XMP:CreateDate. The
Quicktime:CreateDate, and all the
ModifyDate tags are inconsistant.
The file system time stamps are saved in UTC and will always be adjusted to local time. You
cannot make it show up as a time zone other than the local one unless you change the location settings of the computer.
Thank you both so much for responding.
I spent ages last night trying to get my head around all the different values and time zones, only for May's +1:00 daylight savings in my local time zone to eventually hit me and make sense! StarGeek, your second paragraph perfectly explains it.
Problem solved! Thanks :)
Quote from: StarGeek on January 15, 2025, 11:37:28 AMYou cannot make it show up as a time zone other than the local one unless you change the location settings of the computer.
This isn't quite true. There is the ExifTool API TimeZone option (https://exiftool.org/ExifTool.html#TimeZone) which does work in Windows if you specify a numerical offset.
- Phil
Technically correct (best kind of correct) but that would only be temporary for that exiftool output. The OS is going to otherwise display only the local time zone.
Oh, I see. You meant as displayed by the OS. Correct then. :)
- Phil