Re: [GENERAL] Problems with the time in data type timestamp without time zone

2017-10-19 Thread rob stone
On Thu, 2017-10-19 at 10:28 -0400, américo bravo astroña wrote: > We are using two different programs within the same computer, a > program saves the data with date and time in the DB and we are doing > another program to retrieve that information with date and time to > generate reports, all

Re: [GENERAL] Problems with the time in data type timestamp without time zone

2017-10-19 Thread américo bravo astroña
We are using two different programs within the same computer, a program saves the data with date and time in the DB and we are doing another program to retrieve that information with date and time to generate reports, all this within the same computer. Best regards. 2017-10-18 11:33 GMT-04:00

Re: [GENERAL] Problems with the time in data type timestamp without time zone

2017-10-19 Thread Achilleas Mantzios
On 18/10/2017 18:02, Root2 wrote: Hi, I have a program that saves information in a DB Postgresql need to extract data from date and time of that DB but when I retrieve the date and time information is always ahead 3 hours, the type of data that has that field is timestamp without time zone,

[GENERAL] Problems with the time in data type timestamp without time zone

2017-10-19 Thread Root2
Hi, I have a program that saves information in a DB Postgresql need to extract data from date and time of that DB but when I retrieve the date and time information is always ahead 3 hours, the type of data that has that field is timestamp without time zone, I appreciate your time and attention.

Re: [GENERAL] Problems with the time in data type timestamp without time zone

2017-10-18 Thread Basques, Bob (CI-StPaul)
Where is the machine running the database physically located, in another timezone possibly? bobb On Oct 18, 2017, at 10:33 AM, David G. Johnston > wrote: On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña

Re: [GENERAL] Problems with the time in data type timestamp without time zone

2017-10-18 Thread David G. Johnston
On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña < americobr...@gmail.com> wrote: > Hi, > > I have a program that saves information in a DB Postgresql need to extract > data from date and time of that DB but when I retrieve the date and time > information is always ahead 3 hours, the type

[GENERAL] Problems with the time in data type timestamp without time zone

2017-10-18 Thread américo bravo astroña
Hi, I have a program that saves information in a DB Postgresql need to extract data from date and time of that DB but when I retrieve the date and time information is always ahead 3 hours, the type of data that has that field is timestamp without time zone, Please forgive my english I'm using