"Geert Bijloos" <[EMAIL PROTECTED]> writes: > Try this > SET TIMEZONE TO 'CET'; > SELECT (timestamp with time zone '2000-01-01 UT' + interval '86 days 0 hours > 5 min 0 sec') at time zone 'UT';
> "2000-03-26 23:05:00" -> WRONG On what grounds do you claim that that's wrong? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org