Horton

Re: date_trunc() in a specific time zone

Paul A Jungwirth <pj@illuminatedcomputing.com>

View thread View on postgr.es
From: Paul A Jungwirth <pj@illuminatedcomputing.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: vik.fearing@2ndquadrant.com, Steve Crawford <scrawford@pinpointresearch.com>, andreas@proxel.se, pgsql-hackers@lists.postgresql.org
Date: 2018-10-29T16:58:58Z
Lists: pgsql-hackers 
On Mon, Oct 29, 2018 at 9:53 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> We already have date_trunc() for timestamp-without-tz, so I'm a little
> confused as to what you think is/would be missing.

This patch adds a 3-arg version for date_trunc(text, timestamptz,
text). I'm saying it would be nice to also have a 3-arg version for
date_trunc(text, timestamp, text). It would do the same thing, except
take a timestamp w/o tz and return a timestamp w/o tz.

Paul

Commits

  1. Add a timezone-specific variant of date_trunc().