Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id F089447590B
	for <pgsql-sql@postgresql.org>; Wed, 24 Jul 2002 16:52:42 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id 6CD10382490; Wed, 24 Jul 2002 16:52:31 -0400 (EDT)
From: "Ligia Pimentel" <pimentel_ligia@hotmail.com>
X-Newsgroups: comp.databases.postgresql.sql
Subject: how do I change regional setting for dates?
Date: Wed, 24 Jul 2002 14:38:50 -0500
Organization: .
Lines: 17
Message-ID: <ahn42f$163u$1@news.hub.org>
Reply-To: "Ligia Pimentel" <pimentel_ligia@hotmail.com>
X-Complaints-To: news@hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
To: pgsql-sql@postgresql.org
X-Archive-Number: 200207/398
X-Sequence-Number: 8776

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