Re: to_char_at_timezone()? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: to_char_at_timezone()?
Date
Msg-id 10154.1415145540@sss.pgh.pa.us
Whole thread Raw
In response to to_char_at_timezone()?  (Marko Tiikkaja <marko@joh.to>)
Responses Re: to_char_at_timezone()?  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers
Marko Tiikkaja <marko@joh.to> writes:
> So I got into thinking whether it would make sense to provide a new 
> function, say, to_char_at_timezone() to solve this problem.  For example:
> ...
> Any thoughts?  The patch is quite trivial.

I'm not convinced that it's all that trivial.  Is the input timestamp or
timestamptz, and what's the semantics of that exactly (ie what timezone
rotation happens)?  One's first instinct is often wrong in this area.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: tracking commit timestamps
Next
From: Marko Tiikkaja
Date:
Subject: Re: to_char_at_timezone()?