Re: Problems with the time in data type timestamp without time zone

From: américo bravo astroña <americobravo(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with the time in data type timestamp without time zone
Date: 2017-10-19 14:28:22
Message-ID: CANoG27S_pmadgA3WDVvBqLFnZM4SGqUb0M-0No=hP8OSSCWGug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message STERBECQ Didier 2017-10-19 14:57:14 Re: Table partionning : INSERT with inconsistent return ligne inserted.
Previous Message Tom Lane 2017-10-19 14:20:04 Re: pgpass file type restrictions