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

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 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 <americobrav
> > o@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.
> 
> 


Please do not top post on this list.

Your times are in UTC. You'll need to use the "AT TIME ZONE" construct
to display them  in local time.

HTH,

Robert


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general