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

Поиск
Список
Период
Сортировка
От américo bravo astroña
Тема Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Дата
Msg-id CANoG27S_pmadgA3WDVvBqLFnZM4SGqUb0M-0No=hP8OSSCWGug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Problems with the time in data type timestamp withouttime zone  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Список 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.g.johnston@gmail.com>:
On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña <americobravo@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.​

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] pgpass file type restrictions
Следующее
От: STERBECQ Didier
Дата:
Сообщение: Re: [GENERAL] Table partionning : INSERT with inconsistent returnligne inserted.