Earlier today, I saw on Lemmy that comments made within the last hour since DST were now in the negatives since time had rolled back. If a database uses time like this for search operations, would that interfere with them? Could it corrupt the database?
Almost all databases store time in Unix time stamps, which is just a number counting up. Then the various consumers of that value, such as clocks, convert it based on their need (such as time savings, geographic region, etc). But someone in florida has the same unix timestamp at a given instant as someone in Africa.