Wrong timestamps in MySQL database
Posted: Sat Jul 10, 2004 5:51 pm
Hello,
We have a strange problem with ZM database. We have a lot of pictures taken that have correct timestamp in the image. The faulty date in the database is however always the same: 1969-12-31 16:00:00.
This seems to be related to Unix epoch. Is it possible that these faulty timestamps are generated due to an error?
This issue really bugs me because there is valuable data in these pictures and I am not able to sort them at all because the IDs seem to be reused when old events are deleted from the database.
We have a strange problem with ZM database. We have a lot of pictures taken that have correct timestamp in the image. The faulty date in the database is however always the same: 1969-12-31 16:00:00.
This seems to be related to Unix epoch. Is it possible that these faulty timestamps are generated due to an error?
This issue really bugs me because there is valuable data in these pictures and I am not able to sort them at all because the IDs seem to be reused when old events are deleted from the database.