Re: date_trunc() in a specific time zone

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: vik(dot)fearing(at)2ndquadrant(dot)com
Cc: 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 23:04:10
Message-ID: CADkLM=eyi+J=Bcq+XjmUZeuabdbBd2fX3YHqtGw3bhjmvXUDkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> >> A use case that I see quite a lot of is needing to do reports and other
> >> calculations on data per day/hour/etc but in the user's time zone. The
> >> way to do that is fairly trivial, but it's not obvious what it does so
> >> reading queries becomes just a little bit more difficult.
>
>
+1 A client encountered this exact problem last week, and I was surprised
that the parameter didn't already exist.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2018-10-29 23:08:49 Installation instructions update (pg_ctl)
Previous Message Michael Paquier 2018-10-29 22:47:55 Re: pg_promote not marked as parallel-restricted in pg_proc.dat