Received: from briar.mmrd.com (unknown [208.255.226.182]) by postgresql.org (Postfix) with ESMTP id E7AB64758F2 for ; Thu, 25 Jul 2002 10:29:37 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by briar.mmrd.com (8.11.2/8.11.2) with ESMTP id g6PFSX712647; Thu, 25 Jul 2002 11:28:33 -0400 Received: from [172.25.1.55] ([172.25.1.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id g6PETfx15965; Thu, 25 Jul 2002 10:29:41 -0400 Subject: Re: how do I change regional setting for dates? From: Robert Treat To: Ligia Pimentel Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.5 Date: 25 Jul 2002 10:26:49 -0400 Message-Id: <1027607209.8303.37.camel@camel> Mime-Version: 1.0 X-Archive-Number: 200207/401 X-Sequence-Number: 8779 You can do "show all" inside psql, which will show you all of your current run time settings, including a line that should read "Time Zone is unset" or whatever it is set to. This isn't abundantly clear in the docs, so I'll add some notation there, but if you check out http://www.postgresql.org/idocs/index.php?sql-set.html and http://www.postgresql.org/idocs/index.php?timezones.html it will explain how to update your internal timezone as needed. Robert Treat On Wed, 2002-07-24 at 15:38, Ligia Pimentel wrote: > I live in Guatemala, and our timezone is GMT -6, but my server (postgres 7.1 > on a linux redhat 6.2) is storing the dates in the format > > 2002-07-24 00:00:00-04 ( I this understand represents GMT -4). > > My linux servers gives me the the date and time correctly, so I know is not > a matter of the date of the server, and I checked and its GMT-6 (which is > right) . > > How do I change the regional setting in postgres? > > > Thanks, > > Ligia > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster