Time offset in timeline UTC - local time #2090

Closed
opened 2026-02-05 05:03:57 +03:00 by OVERLORD · 16 comments
Owner

Originally created by @DeltaTango69 on GitHub (Jan 31, 2024).

Hello,

pictures from my Sony Camera has an offset to the pictures from the mobiles. The difference is the timezone. The only difference in the exif data are that in the mobil pictures are two entrys more.

image

image

The "offset" entrys are not in the Sony pictures. Could this be the reason? Other programms only use the information from the datetimeoriginal as Local - time. Than there is no offset in the timeline.

Windows - time taken!

image

Immich - Info - one hour difference !

image

Is it possible to use only the datetimeoriginal withou offset?

Originally posted by @DeltaTango69 in https://github.com/immich-app/immich/discussions/6674

Originally created by @DeltaTango69 on GitHub (Jan 31, 2024). Hello, pictures from my Sony Camera has an offset to the pictures from the mobiles. The difference is the timezone. The only difference in the exif data are that in the mobil pictures are two entrys more. ![image](https://github.com/immich-app/immich/assets/82575543/f88bb548-6255-4302-8a0e-7273109df82f) ![image](https://github.com/immich-app/immich/assets/82575543/0b52447c-ab59-455c-9b2a-d291d0bf50cb) The "offset" entrys are not in the Sony pictures. Could this be the reason? Other programms only use the information from the datetimeoriginal as Local - time. Than there is no offset in the timeline. Windows - time taken! ![image](https://github.com/immich-app/immich/assets/82575543/a905ca4e-817e-4d3f-8dce-dcc72456ef2c) Immich - Info - one hour difference ! ![image](https://github.com/immich-app/immich/assets/82575543/8fbf21e5-a2f1-4d69-8338-b4e64044da70) Is it possible to use only the datetimeoriginal withou offset? _Originally posted by @DeltaTango69 in https://github.com/immich-app/immich/discussions/6674_
Author
Owner

@DeltaTango69 commented on GitHub (Jan 31, 2024):

https://discord.com/channels/979116623879368755/1201824099115216957

@DeltaTango69 commented on GitHub (Jan 31, 2024): https://discord.com/channels/979116623879368755/1201824099115216957
Author
Owner

@etnoy commented on GitHub (Feb 1, 2024):

This is an issue for DSLRs in general, and google photos even has the same issue!

Either you need to add a timezone field to the metadata of your DSLR photos, or add a default TZ to immich by setting the TZ env variable.

@etnoy commented on GitHub (Feb 1, 2024): This is an issue for DSLRs in general, and google photos even has the same issue! Either you need to add a timezone field to the metadata of your DSLR photos, or add a default TZ to immich by setting the TZ env variable.
Author
Owner

@DeltaTango69 commented on GitHub (Feb 1, 2024):

I have added this env setting and with photos is working now! But now the problem is with videos. Apparently an offset is added to the UTC time.

Video was taken at 10:26 UTC - 11:26 +01 GMT. Immich shows 11:26 UTC!!!

image

Here are all times from the metadata

======== 20240120112609.mp4
[System] FileModifyDate : 2024:01:20 20:03:01+01:00
[System] FileAccessDate : 2024:02:01 17:38:31+01:00
[System] FileCreateDate : 2024:01:30 17:02:10+01:00
[QuickTime] CreateDate : 2024:01:20 10:26:09
[QuickTime] ModifyDate : 2024:01:20 10:26:09
[Track1] TrackCreateDate : 2024:01:20 10:26:09
[Track1] TrackModifyDate : 2024:01:20 10:26:09
[Track1] MediaCreateDate : 2024:01:20 10:26:09
[Track1] MediaModifyDate : 2024:01:20 10:26:09
[Track2] TrackCreateDate : 2024:01:20 10:26:09
[Track2] TrackModifyDate : 2024:01:20 10:26:09
[Track2] MediaCreateDate : 2024:01:20 10:26:09
[Track2] MediaModifyDate : 2024:01:20 10:26:09
[ItemList] ContentCreateDate : 2024:01:20 11:26:09+01:00
[XMP-xmp] CreateDate : 2024:01:20 11:26:09
[XMP-xmp] ModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] DerivedFromLastModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] IngredientsLastModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] ManagedFromLastModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] ManifestReferenceLastModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] RenditionOfLastModifyDate : 2024:01:20 11:26:09
[XMP-xmpMM] VersionsModifyDate : 2024:01:20 11:26:09

Match would be the createdate under Quicktime and XMP-xmp. Quicktime is UTC and XMP is local time. Maybe therefore is some confusion? I know that the Quicktime value should be right as UTC. When immich use this time than it would be right!
image

@DeltaTango69 commented on GitHub (Feb 1, 2024): I have added this env setting and with photos is working now! But now the problem is with videos. Apparently an offset is added to the UTC time. Video was taken at 10:26 UTC - 11:26 +01 GMT. Immich shows 11:26 UTC!!! ![image](https://github.com/immich-app/immich/assets/82575543/60506c18-db0a-49ce-8c9a-9f2e11a20aff) Here are all times from the metadata ======== 20240120112609.mp4 [System] FileModifyDate : 2024:01:20 20:03:01+01:00 [System] FileAccessDate : 2024:02:01 17:38:31+01:00 [System] FileCreateDate : 2024:01:30 17:02:10+01:00 [QuickTime] CreateDate : 2024:01:20 10:26:09 [QuickTime] ModifyDate : 2024:01:20 10:26:09 [Track1] TrackCreateDate : 2024:01:20 10:26:09 [Track1] TrackModifyDate : 2024:01:20 10:26:09 [Track1] MediaCreateDate : 2024:01:20 10:26:09 [Track1] MediaModifyDate : 2024:01:20 10:26:09 [Track2] TrackCreateDate : 2024:01:20 10:26:09 [Track2] TrackModifyDate : 2024:01:20 10:26:09 [Track2] MediaCreateDate : 2024:01:20 10:26:09 [Track2] MediaModifyDate : 2024:01:20 10:26:09 [ItemList] ContentCreateDate : 2024:01:20 11:26:09+01:00 [XMP-xmp] CreateDate : 2024:01:20 11:26:09 [XMP-xmp] ModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] DerivedFromLastModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] IngredientsLastModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] ManagedFromLastModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] ManifestReferenceLastModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] RenditionOfLastModifyDate : 2024:01:20 11:26:09 [XMP-xmpMM] VersionsModifyDate : 2024:01:20 11:26:09 Match would be the createdate under Quicktime and XMP-xmp. Quicktime is UTC and XMP is local time. Maybe therefore is some confusion? I know that the Quicktime value should be right as UTC. When immich use this time than it would be right! ![image](https://github.com/immich-app/immich/assets/82575543/a99d5b35-fd8a-425f-bd67-2a1d6d13ca1e)
Author
Owner

@etnoy commented on GitHub (Feb 1, 2024):

Did you refresh metadata for the image?

@etnoy commented on GitHub (Feb 1, 2024): Did you refresh metadata for the image?
Author
Owner

@DeltaTango69 commented on GitHub (Feb 2, 2024):

Yes of course, as described for photos is working now with the TZ entry. But for videos is now wrong.

@DeltaTango69 commented on GitHub (Feb 2, 2024): Yes of course, as described for photos is working now with the TZ entry. But for videos is now wrong.
Author
Owner

@DeltaTango69 commented on GitHub (Feb 3, 2024):

My assumption is right - when I delete this

[XMP-xmp] CreateDate : 2024:01:20 11:26:09
[XMP-xmp] ModifyDate : 2024:01:20 11:26:09

from the metadata, then the correct UTC time from the

[QuickTime] CreateDate : 2024:01:20 10:26:09

is used.

I think the best way is to integrate in your list the

[ItemList] ContentCreateDate : 2024:01:20 11:26:09+01:00

before the createdate. Because here the TZ information is stored.

@DeltaTango69 commented on GitHub (Feb 3, 2024): My assumption is right - when I delete this [XMP-xmp] CreateDate : 2024:01:20 11:26:09 [XMP-xmp] ModifyDate : 2024:01:20 11:26:09 from the metadata, then the correct UTC time from the [QuickTime] CreateDate : 2024:01:20 10:26:09 is used. I think the best way is to integrate in your list the [ItemList] ContentCreateDate : 2024:01:20 11:26:09+01:00 before the createdate. Because here the TZ information is stored.
Author
Owner

@fwsmit commented on GitHub (Feb 16, 2024):

I'm also having the same issue. Pictures taken with my sony A7 (first gen) camera have a wrong time offset in immich. The image is taken at 22:14 GMT+1 (ignore that the computer clock is one minute different). When uploaded to immich via the web interface, it shows a time of 23:14 GMT+1, indicating that it added the time zone offset (+1) to the correct time of the image.

The image is attached below. This should be possible to reproduce by just uploading the image with the web interface.
DSC03509

@fwsmit commented on GitHub (Feb 16, 2024): I'm also having the same issue. Pictures taken with my sony A7 (first gen) camera have a wrong time offset in immich. The image is taken at 22:14 GMT+1 (ignore that the computer clock is one minute different). When uploaded to immich via the web interface, it shows a time of 23:14 GMT+1, indicating that it added the time zone offset (+1) to the correct time of the image. The image is attached below. This should be possible to reproduce by just uploading the image with the web interface. ![DSC03509](https://github.com/immich-app/immich/assets/23078054/8aaf3400-4129-4934-8e17-5afa2b8d634d)
Author
Owner

@aviv926 commented on GitHub (Feb 16, 2024):

For the full discussion regarding the issue on Discord

@aviv926 commented on GitHub (Feb 16, 2024): For the full discussion regarding the issue on [Discord](https://discord.com/channels/979116623879368755/1206309678578016277)
Author
Owner

@fwsmit commented on GitHub (Feb 18, 2024):

The link doesn't work for me. It takes me to an empty channel

@fwsmit commented on GitHub (Feb 18, 2024): The link doesn't work for me. It takes me to an empty channel
Author
Owner

@aviv926 commented on GitHub (Feb 18, 2024):

The link doesn't work for me. It takes me to an empty channel

You need to be a member of the server first
https://discord.com/invite/D8JsnBEuKb

@aviv926 commented on GitHub (Feb 18, 2024): > The link doesn't work for me. It takes me to an empty channel You need to be a member of the server first https://discord.com/invite/D8JsnBEuKb
Author
Owner

@namu-lee commented on GitHub (Mar 8, 2024):

I also have a same problem, when I upload videos without timezone information, it falls to UTC timezone even though I have set the TZ environment variable.

I have added this env setting and with photos is working now! But now the problem is with videos. Apparently an offset is added to the UTC time.

@namu-lee commented on GitHub (Mar 8, 2024): I also have a same problem, when I upload videos without timezone information, it falls to UTC timezone even though I have set the TZ environment variable. > I have added this env setting and with photos is working now! But now the problem is with videos. Apparently an offset is added to the UTC time.
Author
Owner

@DeltaTango69 commented on GitHub (Mar 8, 2024):

I think for videos the TZ variable is useless because videos with no TZ information are UTC.
Normally for videos the quicktime:createdate is written with the UTC time!
The error for me was that in the xmp:createdate was written the local time and in the quicktime:createdate the UTC time, what is right! Unfortunately exiftool delvivers first the xmp metadata and ignored the quicktime metadata. As I deleted the xmp data the video was shown with the right time!

@DeltaTango69 commented on GitHub (Mar 8, 2024): I think for videos the TZ variable is useless because videos with no TZ information are UTC. Normally for videos the quicktime:createdate is written with the UTC time! The error for me was that in the xmp:createdate was written the local time and in the quicktime:createdate the UTC time, what is right! Unfortunately exiftool delvivers first the xmp metadata and ignored the quicktime metadata. As I deleted the xmp data the video was shown with the right time!
Author
Owner

@DeltaTango69 commented on GitHub (Apr 1, 2024):

Solved by myself

@DeltaTango69 commented on GitHub (Apr 1, 2024): Solved by myself
Author
Owner

@fwsmit commented on GitHub (Apr 1, 2024):

How did you solve the problem? I'm still experiencing the problem, so I don't think the issue should be closed until it's fixed in Immich

@fwsmit commented on GitHub (Apr 1, 2024): How did you solve the problem? I'm still experiencing the problem, so I don't think the issue should be closed until it's fixed in Immich
Author
Owner

@DeltaTango69 commented on GitHub (Apr 1, 2024):

See my post before. The exif data was not clear

@DeltaTango69 commented on GitHub (Apr 1, 2024): See my post before. The exif data was not clear
Author
Owner

@MikNolhan commented on GitHub (Jun 5, 2024):

Same issue here, also was entirely user error and not knowing QuickTime tags are all UTC. The EXIF tag does not support timezones in the EXIF:DateTimeOriginal or Exif:CreateDate, and XMP times are expected to have the timezone offset in it, and will override most of those things.

@MikNolhan commented on GitHub (Jun 5, 2024): Same issue here, also was entirely user error and not knowing QuickTime tags are all UTC. The EXIF tag does not support timezones in the EXIF:DateTimeOriginal or Exif:CreateDate, and XMP times are expected to have the timezone offset in it, and will override most of those things.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#2090