Thread: [GENERAL] Problems with the time in data type timestamp without time zone
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, I appreciate your time and attention. Best regards. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Problems with the time in data type timestamp withouttime zone
From
Achilleas Mantzios
Date:
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