Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Problems with the time in data type timestamp withouttime zone - Mailing list pgsql-general

From américo bravo astroña
Subject Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Date
Msg-id CANoG27S_pmadgA3WDVvBqLFnZM4SGqUb0M-0No=hP8OSSCWGug@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Problems with the time in data type timestamp withouttime zone  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] Problems with the time in data type timestamp withouttime zone  (rob stone <floriparob@gmail.com>)
List pgsql-general
Tree view
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 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña <americobravo@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 of data that has that field is timestamp without time zone,

Please forgive my english I'm using translator.

​A minimal SQL example of your problem would help.

David J.​

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pgpass file type restrictions
Next
From: STERBECQ Didier
Date:
Subject: Re: [GENERAL] Table partionning : INSERT with inconsistent returnligne inserted.