From: | Sean Chittenden <sean(at)chittenden(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql-server/src/backend/utils/adt datetime.c |
Date: | 2002-09-05 21:00:39 |
Message-ID: | 20020905210039.GK59269@ninja1.internal |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
> > I think this closes bug #630 as well (inserting data at 2am on a
> > timzone shit). -sc
>
> That would be cool. I don't have a freebsd machine to try it on though;
> can you check CVS tip and see?
>
> FWIW, I get
>
> regression=# select timestamptz '2002-4-7 2:0:0.0';
> timestamptz
> ------------------------
> 2002-04-07 03:00:00-04
> (1 row)
>
> but I got that (on HPUX) before the change too. I think it's correct
> --- essentially, given an "impossible" time in the spring-forward gap,
> we choose to assume that it is meant as local standard time. (In the
> other case at fall-back boundaries, an ambiguous time is likewise
> taken as standard time not DST.)
Looks like this works on HEAD. -sc
--
Sean Chittenden
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-05 21:01:16 | pgsql-server/contrib/pg_dumplo lo_export.c lo_ ... |
Previous Message | Tom Lane | 2002-09-05 20:57:00 | pgsql-server/contrib/dbase dbf.c |