| From: | "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Christopher Sawtell" <csawtell(at)xtra(dot)co(dot)nz>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Re: Problem with Dates |
| Date: | 2001-01-26 18:18:51 |
| Message-ID: | 013801c087c4$72309460$0101a8c0@godzone.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> regression=# select '31/12/2000'::date + '365 days'::timespan;
> ?column?
> ------------------------
> 2001-12-31 00:00:00+13
> (1 row)
>
> This looks promising but I wouldn't call it conclusive, particularly
> since you're probably using a different OS than I am (I'm on HPUX
> 10.20). It would be good to bang on it some more with NZ daylight
> times --- as Christopher says, GMT+13 is a tad unusual.
Is 7.0.3 to 7.1B? simply a reinstall or do I need to unload/reload the
database.
PS: GMT+13 isn't unusual for us Kiwis, that's how its always been since
some twit decided daylight saving was a good idea. The jury is still
out on this one.
Glen.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emils Klotins | 2001-01-26 18:42:44 | Re: #DELETED error when using Access 2000 as frontend |
| Previous Message | Tom Lane | 2001-01-26 18:00:17 | Re: Re: Problem with Dates |