Postgres Pro
Downloads
Home   >   mailing lists

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

From Basques, Bob (CI-StPaul)
Subject Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Date
Msg-id E8708C1D-5F2D-49F4-BCDC-66B486EE1040@ci.stpaul.mn.us
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>)
List pgsql-general
Tree view
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@gmail.com> wrote:

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.​



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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Finally upgrading to 9.6!