timestamp without timezone to have timezone

From: Benjamin Adams <benjamindadams(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: timestamp without timezone to have timezone
Date: 2016-11-06 14:11:57
Message-ID: CADb0XWKD_aGVmqOHfOdPB7dsNSzVzNE+MxnfHW4DRjAXvEz0yA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a server that has a column timestamp without timezone.

Is the time still saved?
if I select column with timestamp it will show server timestamp with
timezone.

But If I move the data from EST to Central will the timestamp with timezone
be correct?
Or will it just not make the adjustment?

Thanks
Ben

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-11-06 15:10:15 Re: timestamp without timezone to have timezone
Previous Message Andreas Joseph Krogh 2016-11-06 11:34:10 Parallel pg_dump/restore and LOs