05-30-2024, 01:17 AM
Hi Mike,
I did a bit more research on the time matter:
On my desktop PC and tablet the time of the MP3 files and the entries in the database are by 1 respectively 2 hours offset and do not match even after two-way sync. In addition some files hold a similar date, while others hold completely different dates between the two devices. Three examples:
a child is born
Database PC: 2024-04-25 18:37:13.643
Filesystem PC: 2024-04-25 20:37:13
Filesystem Tablet: 2024-03-28 12:27:34
Database Tablet: 2024-03-28 11:27:34.0
1999
Database PC: 2024-04-06 18:53:58.634
Filesystem PC: 2024-04-06 20:53:58
Filesystem Tablet: 2024-04-06 20:54:12
Database Tablet: 2024-04-06 18:54:12.0
Honey Pie
Database PC: 2022-01-13 16:26:02.77
Filesystem PC: 2022-01-13 17:26:02
Filesystem Tablet: 2024-03-28 15:28:50
Database Tablet: 2024-03-28 14:28:50.0
Both devices are in the same time zone and hold the correct and same system time (at least to the minute level which is displayed by Windows).
The database time was retrieved by SQLite formatiing the date as Java-Epoche (ms).
The filesysystem time is the last changed date retrieved using total commander attributes.
Regards Thomas
I did a bit more research on the time matter:
On my desktop PC and tablet the time of the MP3 files and the entries in the database are by 1 respectively 2 hours offset and do not match even after two-way sync. In addition some files hold a similar date, while others hold completely different dates between the two devices. Three examples:
a child is born
Database PC: 2024-04-25 18:37:13.643
Filesystem PC: 2024-04-25 20:37:13
Filesystem Tablet: 2024-03-28 12:27:34
Database Tablet: 2024-03-28 11:27:34.0
1999
Database PC: 2024-04-06 18:53:58.634
Filesystem PC: 2024-04-06 20:53:58
Filesystem Tablet: 2024-04-06 20:54:12
Database Tablet: 2024-04-06 18:54:12.0
Honey Pie
Database PC: 2022-01-13 16:26:02.77
Filesystem PC: 2022-01-13 17:26:02
Filesystem Tablet: 2024-03-28 15:28:50
Database Tablet: 2024-03-28 14:28:50.0
Both devices are in the same time zone and hold the correct and same system time (at least to the minute level which is displayed by Windows).
The database time was retrieved by SQLite formatiing the date as Java-Epoche (ms).
The filesysystem time is the last changed date retrieved using total commander attributes.
Regards Thomas