Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DC6CB9FB546 for ; Thu, 14 Jun 2007 04:02:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 92450-02 for ; Thu, 14 Jun 2007 04:02:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id 7437A9FB3CB for ; Thu, 14 Jun 2007 04:02:48 -0300 (ADT) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis), id 0ML2xA-1HyjLz0Ukn-0000uu; Thu, 14 Jun 2007 09:02:47 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HyjLy-00052R-00 for pgsql-sql@postgresql.org; Thu, 14 Jun 2007 09:02:46 +0200 Date: Thu, 14 Jun 2007 09:02:46 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: function to find difference between in days between two dates Message-ID: <20070614070246.GB16034@a-kretschmer.de> References: <006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19/YVLw6yFAQnPXejuUkn60YI7vZlAxGqK6mjz dz7gfamopO1rVidw37AEDSzSuLzc1OURY8mUyqOfi75BubvYxI GEA+RGvkukAJji8z7wigk0y0qyi60TG X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/101 X-Sequence-Number: 28591 am Thu, dem 14.06.2007, um 11:56:15 +0530 mailte Ashish Karalkar folgendes: > Hello all, > > Is there any function to find differences in days between two dates? Yes, age(). Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net