Re: Yet Another Timestamp Question: Time Defaults - Mailing list pgsql-general

From Rich Shepard
Subject Re: Yet Another Timestamp Question: Time Defaults
Date
Msg-id alpine.LNX.2.00.1301211136260.30221@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Yet Another Timestamp Question: Time Defaults  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 21 Jan 2013, Tom Lane wrote:

> Note that that default is local midnight according to your current
> timezone setting (from which we may guess that Adrian lives on the US west
> coast, or somewhere in that general longitude).

   Yep. About 3 hours north of me.

>> Not sure you can change the default supplied by Postgres,
> "SET timezone" ought to do it ...

   Thanks, Tom.

Rich



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Yet Another Timestamp Question: Time Defaults
Next
From: Adrian Klaver
Date:
Subject: Re: Yet Another Timestamp Question: Time Defaults