Received: from hotmail.com (f159.law14.hotmail.com [64.4.21.159]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66J7ra34100 for ; Fri, 6 Jul 2001 15:07:53 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 6 Jul 2001 12:07:50 -0700 Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP; Fri, 06 Jul 2001 19:07:50 GMT X-Originating-IP: [213.29.16.6] From: "omid omoomi" To: tanethq@earthlink.net, pgsql-general@postgresql.org Subject: Re: Number of days Date: Fri, 06 Jul 2001 19:07:50 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 06 Jul 2001 19:07:50.0837 (UTC) FILETIME=[F3AAFE50:01C1064E] X-Archive-Number: 200107/190 X-Sequence-Number: 12111 select date_part('day','@ 4 days 3 hours 2 mins'); date_part --------- 4 HTH Omid >From: "Mihai Gheorghiu" >To: >Subject: [GENERAL] Number of days >Date: Fri, 6 Jul 2001 14:47:39 -0400 > >Is there a function that returns the number of days between two dates? >I found only age, which calculates the difference between two timestamps, >but the example shows the result as a timestamp. >Thanks, >Mihai Gheorghiu > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://www.postgresql.org/search.mpl _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.