Postgres Pro
Downloads
Home   >   mailing lists

timestamp without timezone to have timezone - Mailing list pgsql-general

From Benjamin Adams
Subject timestamp without timezone to have timezone
Date
Msg-id CADb0XWKD_aGVmqOHfOdPB7dsNSzVzNE+MxnfHW4DRjAXvEz0yA@mail.gmail.com
Whole thread Raw
Responses Re: timestamp without timezone to have timezone  (Melvin Davidson <melvin6925@gmail.com>)
Re: timestamp without timezone to have timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Parallel pg_dump/restore and LOs
Next
From: Melvin Davidson
Date:
Subject: Re: timestamp without timezone to have timezone