Re: timestamp arithmetic - Mailing list pgsql-bugs

From Tom Lane
Subject Re: timestamp arithmetic
Date
Msg-id 13000.1103246696@sss.pgh.pa.us
Whole thread Raw
In response to timestamp arithmetic  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-bugs
"Ed L." <pgsql@bluepolka.net> writes:
> Note the queries below generate the same result regardless of the timezone input:

This isn't a bug.  Per documentation:

: For timestamp [without time zone], any explicit time zone specified in
: the input is silently ignored. That is, the resulting date/time value is
: derived from the explicit date/time fields in the input value, and is
: not adjusted for time zone.

You want to use timestamp with time zone (timestamptz), I think.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Ed L."
Date:
Subject: timestamp arithmetic
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1350: Backslash ecape charcter violates ISO/ANSI spec and is hazardous