Re: Problems with the time in data type timestamp without time 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(dot)g(dot)johnston(at)gmail(dot)
> com>:
> > On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña <americobrav
> > o(at)gmail(dot)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