Re: Question about timezones - Mailing list pgsql-general

From Steven Klassen
Subject Re: Question about timezones
Date
Msg-id 20041007204349.GC19692@commandprompt.com
Whole thread Raw
In response to Question about timezones  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Question about timezones  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
* Martijn van Oosterhout <kleptog@svana.org> [2004-10-07 22:22:24 +0200]:

> Is there any way I can use these from within postgresql? Those files
> contains details about daylight saving changes and other useful
> details like that, which a simple PST or EST won't cover. Or should
> I simply do all my date/time conversion in my application?

The time zone support seems pretty exhaustive. Check out section B-r
in the document below.

http://www.postgresql.org/docs/7.4/static/datetime-keywords.html

HTH,

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

pgsql-general by date:

Previous
From: Steven Klassen
Date:
Subject: Re: PSQL undesired transaction behavior when connection is lost.
Next
From: Tom Lane
Date:
Subject: Re: DDL triggers [was Re: database constraints]