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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match