select date_part('day','@ 4 days 3 hours 2 mins');
date_part
---------
4
HTH
Omid
>From: "Mihai Gheorghiu" <tanethq@earthlink.net>
>To: <pgsql-general@postgresql.org>
>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.