Re: [GENERAL] Problems with the time in data type timestamp withouttime zone - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
Date
Msg-id d93dbd1d-81ff-7b51-c8d4-fcad0d11d912@matrix.gatewaynet.com
Whole thread Raw
In response to [GENERAL] Problems with the time in data type timestamp without time zone  (Root2 <americobravo@gmail.com>)
List 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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: [GENERAL] Log storage
Next
From: Andrew Dunstan
Date:
Subject: Re: [GENERAL] pgpass file type restrictions