Re: date_trunc() in a specific time zone

From: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: vik(dot)fearing(at)2ndquadrant(dot)com, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, andreas(at)proxel(dot)se, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: date_trunc() in a specific time zone
Date: 2018-10-29 16:58:58
Message-ID: CA+renyXrccGTKhvQ4hgPdtsWOb14JnE_ZFEPE74_qywUfgtXwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 29, 2018 at 9:53 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul A Jungwirth 2018-10-29 17:13:10 Re: date_trunc() in a specific time zone
Previous Message Tom Lane 2018-10-29 16:53:16 Re: date_trunc() in a specific time zone