←back to thread

Timestamps and Time Zones in PostgreSQL (2016)

(phili.pe)
189 points GordonS | 2 comments | 30 Mar 19 21:47 UTC | HN request time: 0s | source
Show context
cpeterso ◴[31 Mar 19 00:04 UTC] No.19532799[source]▶
What timestamp types are available in MySQL, SQL Server, and Oracle?
replies(5): >>19532853 #>>19532902 #>>19533224 #>>19533575 #>>19533819 #
userbinator ◴[31 Mar 19 03:18 UTC] No.19533575[source]▶
SQL Server has datetimeoffset, which computes in UTC but also stores the timezone.
replies(1): >>19534190 #
1. crooked-v ◴[31 Mar 19 06:19 UTC] No.19534190[source]▶
Does it store the time zone, or does it store the offset?
replies(1): >>19535099 #
2. GordonS ◴[31 Mar 19 11:44 UTC] No.19535099[source]▶
AFAIK, it stores the offset