Am 11.01.19 um 07:50 schrieb Ty Mayn:
> What is the format of the 13 digit Long integer that represents
> Last Modified, Last Modified XMP and also for Exif Last Modified Timestamp
> I checked out the regular date format fields for last modified and
> tried converting to them
> Julian dates which were not even close to these mysterious numbers.
It's the last modification time of the files, according to the Java documentation:
A long value representing the time the file was last modified, measured in milliseconds since the epoch (00:00:00 GMT, January 1, 1970).
For human readability, the milliseconds from begin of 1970 to the file modification time have to be converted into a timestamp. With JPhotoTagger's HSQLDB version that can be done via:
"org.hsqldb.HsqlDateTime.getTimestamp"(LASTMODIFIED) AS image_file_last_modified,
"org.hsqldb.HsqlDateTime.getTimestamp"(XMP_LASTMODIFIED) AS xmp_sidecar_file_last_modified
When trying to do this with LibreOffice Base, it results in a syntax error message by LibreOffice but not from the database driver. To get proper results, you can use a more advanced tool such as SQuirreL SQL Client (http://squirrel-sql.sourceforge.net/
). I attached a screenshot with the result of that query (SQuirreL SQL).
Please note, that accessing JPhotoTagger's database via other clients such as LibreOffice or SQuirreL SQL is not included in JPhotoTagger's support.