Re: [HACKERS] timezone problem?

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] timezone problem?
Date: 2000-01-20 16:51:29
Message-ID: Pine.BSF.4.05.10001201148230.8515-100000@paprika.michvhf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 20 Jan 2000, Tom Lane wrote:

> Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> > On my RH-5.2 box, "JST" is not in /usr/share/zoneinfo. A non-existant
> > TZ evaluates to be GMT, but the system reports the string you gave
> > it!! I don't recall ever running across this before.
>
> Ugh. RedHat's not the only one: on my HPUX 10 box,
>
> $ date
> Thu Jan 20 11:13:26 EST 2000
> $ TZ=GMT date
> Thu Jan 20 16:13:30 GMT 2000
> $ TZ=ZZZ date
> Thu Jan 20 16:13:35 ZZZ 2000
> $ TZ=foo date
> Thu Jan 20 16:13:53 foo 2000
>
> This may be a fairly widespread bug^H^H^Hbizarre behavior.

Odd. Here's how FreeBSD acts:

$ TZ=GMT date
Thu Jan 20 16:47:29 GMT 2000
$ TZ=foo date
Thu Jan 20 16:47:36 GMT 2000
$ TZ=EDT date
Thu Jan 20 16:47:47 GMT 2000
$ TZ=EST date
Thu Jan 20 11:47:54 EST 2000
$ TZ=PST date
Thu Jan 20 16:48:03 GMT 2000
$ TZ=ZZZ date
Thu Jan 20 16:48:09 GMT 2000
$ TZ=JST date
Thu Jan 20 16:49:00 GMT 2000
$ TZ=MST date
Thu Jan 20 09:50:05 MST 2000
$ TZ=CST date
Thu Jan 20 16:49:32 GMT 2000

Strange, it does MST and EST but not CST and PST.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
128K ISDN: $24.95/mo or less - 56K Dialup: $17.95/mo or less at Pop4
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-20 16:52:47 Re: [HACKERS] timezone problem?
Previous Message Patrick Welche 2000-01-20 16:40:25 Re: [HACKERS] COPY problems with psql / libpq