Re: [BUGS] Postgresql 7.0 bug

2000-05-29 Thread Karl DeBisschop
root wrote: > > When I execute from psql: > SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp; > > I get: > ?column? > -- > 23:00 > (1 row) > > Why april 2nd, 2000 don't last 1 day (or 24 hours) ? Because April 2nd was the beginning of d

Re: [BUGS] Postgresql 7.0 bug

2000-05-28 Thread Tom Lane
root <[EMAIL PROTECTED]> writes: > SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp; >?column? > -- >23:00 > (1 row) > Why april 2nd, 2000 don't last 1 day (or 24 hours) ? Here in the USA, that is the right answer because 4/2 was a daylight savin