]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5ba04cd) | patch
timestamptz_trunc() should only recalculate the timezone when truncating
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 1 Nov 2004 22:00:30 +0000 (22:00 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 1 Nov 2004 22:00:30 +0000 (22:00 +0000)
commitc4acbb843b0b10204b04be6245db57d50f9cee0e
treef9fa5973c62b9c205b7c798d316acc4712be9453tree | snapshot
parent5ba04cd9f17ac91cce7460310a2a6cbd714b7e8acommit | diff
timestamptz_trunc() should only recalculate the timezone when truncating
to DAY precision or coarser; leave the timezone alone when precision is
HOUR or less.  This avoids surprises for inputs near a DST transition
time, as per example from Matthew Gabeler-Lee.  (The only reason we
recalculate at all is so that outputs that are supposed to represent
days will come out as local midnight, and that's not relevant for sub-day
precision.)
src/backend/utils/adt/timestamp.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.