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@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. > > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
