On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
It depends on how you are declaring the timestamp field. If you do not use with time zone then the input value is open to interpretation and is not 'anchored' to a point in time.
Example
My time zone is currently PST.
test=> create table timestamp_test(id int, ts timestamp, ts_z timestamp with time zone);
CREATE TABLE
test=> insert into timestamp_test values (1, now(), now());
INSERT 0 1
.....
If you know what time zone the value was inserted under you can get it back.
.
.
That assumes a lot, so the best thing is to use timestamp with time zone.
Thanks for trying this out on your setup. However looks like my requirement is different here.
Regards...
