pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow do I change regional setting for dates?
2+ messages / 2 participants
[nested] [flat]
* how do I change regional setting for dates?
@ 2002-07-24 19:38 Ligia Pimentel <pimentel_ligia@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ligia Pimentel @ 2002-07-24 19:38 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how do I change regional setting for dates?
@ 2002-07-25 14:26 Robert Treat <rtreat@webmd.net>
parent: Ligia Pimentel <pimentel_ligia@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Treat @ 2002-07-25 14:26 UTC (permalink / raw)
To: Ligia Pimentel <pimentel_ligia@hotmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-25 14:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-24 19:38 how do I change regional setting for dates? Ligia Pimentel <pimentel_ligia@hotmail.com>
2002-07-25 14:26 ` Robert Treat <rtreat@webmd.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox