how do I change regional setting for dates?

From: "Ligia Pimentel" <pimentel_ligia(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: how do I change regional setting for dates?
Date: 2002-07-24 19:38:50
Message-ID: ahn42f$163u$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message marc sturm 2002-07-25 00:48:19 convert a bigint into a timestamp
Previous Message Wim 2002-07-24 19:10:41 Trying to write a function...