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

["Basques, Bob (CI-StPaul)" <bob.basques@xxxxxxxxxxxxxxx>]

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 <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña <americobravo@xxxxxxxxx> 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.​

Don’t ever wrestle with a pig. You’ll both get dirty, but the pig will enjoy it.

—Cale Yarborough