On Tue, Aug 20, 2013 at 2:23 PM, Adrian Klaver wrote:
> PostgreSQL never examines the content of a literal string before determining
> its type, and therefore will treat both of the above as timestamp without
> time zone. To ensure that a literal is treated as timestamp with time zone,
> give it t
On 08/20/2013 04:00 AM, Daniele Varrazzo wrote:
Hello,
the issue can be show with this example:
piro=> SET TIMEZONE = 'America/New_York';
SET
piro=> select '1970-01-01T00:00:00+03:00'::timestamp;
timestamp
-
1970-01-01 00:00:00
(1 r
