pressie# select '31/12/2000'::date + '1 year'::timespan;
?column?
-----------------------------
01/01/2002 00:00:00.00 NZDT
(1 row)
pressie=#
Well I do :-(
I vaguely remember someone else having the same problem and it was
something to do with daylight saving. I don't recall the solution
though, if there was one.
Glen.
- [SQL] Problem with Dates Glen and Rosanne Eustace
- Re: [SQL] Problem with Dates Mike Castle
- [SQL] Veering OT opinions please XQL ve... clayton cottingham
- [SQL] Re: Problem with Dates Glen and Rosanne Eustace
- [SQL] Re: Problem with Dates Mike Castle
- [SQL] Re: Problem with Dates Glen and Rosanne Eustace
- Re: [SQL] Re: Problem with ... Christopher Sawtell
- Re: [SQL] Re: Problem w... Tom Lane
- Re: [SQL] Re: Probl... Glen and Rosanne Eustace
- Re: [SQL] Re: Probl... Tom Lane
- Re: [SQL] Re: Probl... Glen and Rosanne Eustace
- Re: [SQL] Re: Probl... Brett W. McCoy
- Re: [SQL] Re: Probl... Glen and Rosanne Eustace
- Re: [SQL] Re: Probl... Brett W. McCoy
