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 eBU0b8L48438 for ; Fri, 29 Dec 2000 19:37:08 -0500 (EST) (envelope-from koester@x-itec.de) Received: from bastion.localhost (p3E9E176E.dip.t-dialin.net [62.158.23.110]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id BAA09939 for ; Sat, 30 Dec 2000 01:37:08 +0100 (MET) Received: from masterpc (master [192.168.0.1]) by bastion.localhost (8.11.1/8.11.1) with ESMTP id eBU0bgb02384 for ; Sat, 30 Dec 2000 00:37:42 GMT Date: Sat, 30 Dec 2000 01:36:25 -0800 From: Boris X-Mailer: The Bat! (v1.48f) Personal Reply-To: Boris X-Priority: 3 (Normal) Message-ID: <7225221807.20001230013625@x-itec.de> To: pgsql-sql@postgresql.org Subject: Date/Time problem -((( Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/296 X-Sequence-Number: 633 Hello I am moving from MySQL to Postgres and while converting my sql code I have a lot of problems with this construction: ($ze is current time - 300 secounds): delete from onlineuser where datum < FROM_UNIXTIME($ze) Is there any Date/Time function in PGSQL? I want as shown in this example delete entries older than 300 secounds. I postet to the list because I have found no solution in the tutorials and search-engine (maybe searched with wrong words?) It would be great if someone could help me / point me to the right way... -- Boris