On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver <adrian.kla...@aklaver.com>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...