Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Adrian Klaver
On 11/06/2016 09:24 AM, Benjamin Adams wrote: Please Reply to list also. I have Cced list > On Nov 6, 2016 11:07 AM, "Adrian Klaver" > wrote: >> >> On 11/06/2016 06:11 AM, Benjamin Adams wrote: >> > I have a server that has a column timestamp without timezone. >

Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Steve Crawford
On Sun, Nov 6, 2016 at 7:10 AM, Melvin Davidson wrote: > > > > On Sun, Nov 6, 2016 at 9:11 AM, Benjamin Adams wrote: >> >> I have a server that has a column timestamp without timezone. >> >> Is the time still saved? >> if I select column with timestamp it will show server timestamp with timezone.

Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Adrian Klaver
On 11/06/2016 06:11 AM, Benjamin Adams wrote: > I have a server that has a column timestamp without timezone. > > Is the time still saved? Yes the timestamp is always saved. What that timestamp is differs: test[5432]=# create table ts_tsz_test(fld_1 timestamp, fld_2 timestamp with time zone);

Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Melvin Davidson
On Sun, Nov 6, 2016 at 9:11 AM, Benjamin Adams wrote: > I have a server that has a column timestamp without timezone. > > Is the time still saved? > if I select column with timestamp it will show server timestamp with > timezone. > > But If I move the data from EST to Central will the timestamp w