Received: from post.webmailer.de (natmail2.webmailer.de [192.67.198.65]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f02D2eL75633 for ; Tue, 2 Jan 2001 08:02:40 -0500 (EST) (envelope-from koester@x-itec.de) Received: from bastion.localhost (p3E9D3DA4.dip.t-dialin.net [62.157.61.164]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id OAA18755; Tue, 2 Jan 2001 14:02:13 +0100 (MET) Received: from masterpc (master [192.168.0.1]) by bastion.localhost (8.11.1/8.11.1) with ESMTP id f02D2xF10242; Tue, 2 Jan 2001 13:02:59 GMT Date: Tue, 2 Jan 2001 14:01:22 -0800 From: Boris X-Mailer: The Bat! (v1.48f) Personal Reply-To: Boris X-Priority: 3 (Normal) Message-ID: <99201708120.20010102140122@x-itec.de> To: "Francis Solomon" CC: pgsql-sql@postgresql.org Subject: Re[2]: Date/Time problem -((( In-reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/13 X-Sequence-Number: 674 Hello Francis, Tuesday, January 02, 2001, 3:23:49 AM, you wrote: FS> Hi Boris, FS> I know Kaare Rasmussen posted a URL to the online documentation already, FS> but this might be a direct solution to your problem: FS> DELETE FROM onlineuser WHERE datum < ('now'::datetime - '5 FS> minutes'::interval); FS> Hope this helps FS> Francis Solomon Yes this helps me a lot thanks!!!! -- Boris