alt Hacker NewsThis is all well and good until you need to represent something that happened on Jan 1 1970 00:00 UTC.
Replies
BeFlatXIII • 04/24/2025
Leave it null for non-deleted items.
This is all well and good until you need to represent something that happened on Jan 1 1970 00:00 UTC.
Leave it null for non-deleted items.
32-bit UNIX timestamps are often signed so you can actually go before that, but most UNIX timestamps are 64-bit now, which can represent quite a larger range. And SQL datetime types might have a totally different range.
Not that it really matters; deleted_at times for your database records will rarely predate the existence of said database.