5 ms·
Storing 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 m
by TheAceOfHearts 8y ago
Storing 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.