Hello,
I am using Drill 1.20.2 on Fedora Linux 37. I have setup a query to retrieve
the metadata of the pictures I have taken just a few days ago with my
smartphone (Samsung S21-FE). I copied the files yesterday from my smartphone to
my computer. The query runs in my ETL tool (tweakstreat.io) and I want to
retrieve the datetime when the shot was taken(from ExifIFD0) and also use the
datetime of the picture on the filesystem.
That works well, the only thing strange is that the FileDateTime on all
pictures shows: Do. Jan. 01 02:00:00 +01:00 1970 (German format). I have
checked the files manually on the filesystem and they do have a correct
timestamp (different from 1970) on the filesystem. Where is the FileDateTime
value actually comming from?? I assume from the filesystem and not from the
picture metadata, right? Even stranger, when I process some older pictures from
2019 e.g., then the FileDateTime is displayed correctly - but I must admit,
that I had a different smartphone at that time (though also a Samsung).
Can anybody help me with this?
A side question is if it is possible to reformat the FileDateTime value
returned from the query to a different format. I just simply cannot find a
pattern that would work.
Regards,
Uwe
