On 04/17/2008 05:58 PM, Christopher Browne wrote:
> James T Mugauri <james at africonnect.co.zm> writes:
>   
>   
Thanks, Chris
> "Principle: Use an unambiguous, stable time zone such as UTC or GMT.
>
> It is furthermore preferable to
> use a time zone where times do not shift around due to Daylight
> Savings Time.
>
> The "geographically unbiased" choice seems to be TZ=UTC or TZ=GMT, and
> to make sure that systems are "in sync" by using NTP to synchronize
> clocks throughout the environment.
>   
I'n using Central Africa Time, which is clearly defined in 
/usr/share/pgsql/timezones (in Africa.txt) and there's no Daylight 
Savings Times here. I'm loathe to mess with the apps that rely on the db.

If I have to use GMT, where is the change effectively made (aside from 
timezone_abbreviations in postgres)?
> See also Section 3.4.
> [http://linuxfinances.info/info/requirements.html#TIMES]"
>
> Hope that helps!
>   
Thanks. It's a start