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