Re: When DST occurs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Clift <aa2(at)bigpond(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When DST occurs
Date: 2001-05-04 23:03:53
Message-ID: 2271.989017433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Justin Clift <aa2(at)bigpond(dot)net(dot)au> writes:
> I'm trying to figure out how DST change times will affect a running database?

The usual theory in Unix-based software is to keep everything in GMT
internally, so the data isn't affected at all by timezone changes.
Timezone just affects display of timestamp values.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-04 23:08:41 Re: IpcMemoryCreate: shmget failed (Invalid argument)
Previous Message Tom Lane 2001-05-04 23:01:05 Re: Re: commit_delay CANCEL