3 ms·
Largely timestamping. Accuracy to a high level (leap seconds) is irrelevant. Aware of 2038 problem, assume we will have some fun along the way to there along wi
by robbiep 8y ago
Largely timestamping. Accuracy to a high level (leap seconds) is irrelevant.
Aware of 2038 problem, assume we will have some fun along the way to there along with the rest of the unix world!
- TheAceOfHearts 8y agoStoring Unix timestamps in a 64-bit signed integer field would probably be fine in that situation. The only downsides that come to mind are that you'd have to manually convert the number to an actual date when using it, and that you'd lose easy access to date-related functionality in the database.
- jeltz 8y agoBut also totally pointless since PostgreSQL's timestamptz type also uses 64 bits.