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