Re: Timezone fun (bugs and a request) - Mailing list pgsql-hackers

Zeugswetter Andreas SB SD wrote:
>>   LOG:  database system was shut down at 2004-05-25 15:15:44 GMT-12
>>
>>For comparison, 7.4.1 on the same system says:
>>
>>   LOG:  database system was shut down at 2004-05-25 16:03:43 NZST
> 
> 
>>Can we keep the zic database convention unchanged but change the display 
>>format in the logs to be consistent with the SQL conventions?
> 
> 
> I think what was meant is, that if it displays GMT+-something it should
> convert the sign. Is that zic filename exposed anywhere else ?
> 
> It is common practice that + is East and - is West, no ?

Yes, exactly. Regardless of how the timezone is handled internally, 
showing 12-hours-east as GMT-12 in logs is horribly confusing.

-O