Dates

Hi Guys,

I am in troubles with some dates.


"I need to know the difference, in days, between two
dates."

Well, if the difference is less than a month, so I
could use:

SELECT date_part('day', age(now(), mydate));

But, when it is bigger than a month, the select above
return a wrong information to me:

For instance:

intranet=# select age('30/01/2004', '01/03/2004');
          age
-----------------------
 @ 1 mon 2 days 1 hour

So, if I use date_part(), it would return "2 days",
not "31 days", that is what I was waiting for.

How can I get the difference, in days, between two
dates???

Thanks in advance and
Best Regards,



______________________________________________________________________

Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
http://br.yahoo.com/info/mail.html