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

Re: [GENERAL] Timestamp without timezone

2007-11-20 Thread T.J. Adami
On 20 nov, 12:35, [EMAIL PROTECTED] (Reg Me Please) wrote: > Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto: > > > > > I'm using Microsoft Visual Foxpro 9 developing an ERP application, > > using PostgreSQL 8.2.5 and ODBC connection in version 7. > > > If I upgrade my ODBC drivers to us

Re: [GENERAL] Timestamp without timezone

2007-11-20 Thread Reg Me Please
Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto: > I'm using Microsoft Visual Foxpro 9 developing an ERP application, > using PostgreSQL 8.2.5 and ODBC connection in version 7. > > If I upgrade my ODBC drivers to use "PostgreSQL ANSI", becomes an > error like this: > > "function saldo_es