(phili.pe)

189 points GordonS | 1 comments | 30 Mar 19 21:47 UTC | HN request time: 0.413s | source

Show context

robbiep ◴[31 Mar 19 02:29 UTC] No.19533377[source]▶

>>19532090 (OP) #

I have a question, that was partially addressed in some comments in the last Timezone in Databases article earlier in the week -

What do people think about using Unix time in databases?

replies(4): >>19533555 #>>19533627 #>>19533651 #>>19535478 #

1. paulryanrogers ◴[31 Mar 19 03:13 UTC] No.19533555[source]▶

>>19533377 #

Directly using Unix timestamps is unlikely to save much space since most internal representations are likely similar. They're also difficult for mortals to read and change in human-significant ways (like 3 calendar days ago).

↑

Timestamps and Time Zones in PostgreSQL (2016)