Subject: Re: Number of days

From: "omid omoomi" <[email-masked]>
Date: Fri, 06 Jul 2001 19:07:50

select date_part('day','@ 4 days 3 hours 2 mins');

date_part
---------
        4

HTH
Omid

>From: "Mihai Gheorghiu" <[email-masked]>
>To: <[email-masked]>
>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.