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

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with the time in data type timestamp without time zone
Date: 2017-10-19 11:45:58
Message-ID: d93dbd1d-81ff-7b51-c8d4-fcad0d11d912@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18/10/2017 18:02, Root2 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,

Your program is Java? Anyways, if your local TZ is +3 (like mine at the moment) it would be likely the case.

>
> I appreciate your time and attention.
>
> Best regards.
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Dunstan 2017-10-19 12:22:18 Re: pgpass file type restrictions
Previous Message Condor 2017-10-19 11:33:06 Re: Log storage