Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id A8C0547633F for ; Mon, 25 Feb 2002 15:32:04 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1PKMuX88454 for pgsql-sql@postgresql.org; Mon, 25 Feb 2002 14:22:56 -0600 (CST) (envelope-from news) From: panjas51@yahoo.fr (panjas51) X-Newsgroups: comp.databases.postgresql.sql Subject: [CHALLANGE] Add seconds to a date Date: 25 Feb 2002 08:16:06 -0800 Organization: http://groups.google.com/ Lines: 12 Message-ID: <3c1b889f.0202250816.298b7afd@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200202/403 X-Sequence-Number: 6825 I tried to make a PLSQL (oracle) function in order to add some seconds to a specified date: Let's take a exemple: New_date=sec2date(#2002-02-02#, 100), this should add 100 seconds to the entered date: this should then return "2002-02-02 00:01:40". Attention to the lead year. If any one wants to take this challage or propose some quick wins idees