Problems with the time in data type timestamp without time zone

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