3 ms·
Sometimes I think Mysql has corrupted everyone's brain. Postgresql and every other database that I'm aware of stores dates internally as a 4 or 8 bit number an
by nathanstitt 14y ago
Sometimes I think Mysql has corrupted everyone's brain.
Postgresql and every other database that I'm aware of stores dates internally as a 4 or 8 bit number anyway, so you aren't saving anything by using an (hopefully) bigint instead of a datetime column.
- jfb 14y ago"Sometimes I think Mysql has corrupted everyone's brain." Unsurprising, given how cavalier MySQL is with all the other data it "stores".
- justincormack 14y agoI hope you meant 4 or 8 bytes not bits....
- nathanstitt 14y agoYes, bytes. I suppose most everyone wants to use dates more than 256 seconds past Jan 1, 1970. cue embarrassment