On Mon, Nov 21, 2005 at 03:59:39PM +0000, David Begley wrote: > > The following bug has been logged online: > > Bug reference: 2062 > Logged by: David Begley > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Windows > Description: Timezone unrecognised > Details: > > Sorry this is probably going to be a "PITA" issue. > > PostgreSQL documentation (and basic testing with "psql") indicates that for > the Australian eastern coast, the timezones "AEST" (UTC+10) and "AESST" > (UTC+11) are recognised; unfortunately the far more popular "AEDT" (UTC+11, > "Australian Eastern Daylight-Saving Time") is not recognised. > > I don't know where the idea that "AESST" is popular in Australia originated > - a Google for "aesst +site:.au" versus "aedt +site:.au" shows 432 hits for > "AESST" and over 1.3 million for "AEDT". Even limiting the search to > ".gov.au" is strongly in favour of "AEDT" (93 versus over 38,000).
The issue is that PostgreSQL gets it's timezone data from somewhere else; see http://lnk.nu/developer.postgresql.org/69i. Now, why it's comming from a machine at the National Cancer Institute I don't know... presumably it's a project for someone who works there. You should take a look at the comments at the end of http://lnk.nu/developer.postgresql.org/69j. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq