Re: date_trunc() in a specific time zone - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: date_trunc() in a specific time zone
Date
Msg-id CADkLM=eyi+J=Bcq+XjmUZeuabdbBd2fX3YHqtGw3bhjmvXUDkA@mail.gmail.com
Whole thread Raw
In response to Re: date_trunc() in a specific time zone  (Vik Fearing <vik.fearing@2ndquadrant.com>)
List 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. 

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_promote not marked as parallel-restricted in pg_proc.dat
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: Installation instructions update (pg_ctl)