Subtracting two dates/timestamps will return an interval. So
select now()::date - '2004-01-13'::date
returns 34.
Is this what you need?
On Feb 16, 2004, at 2:01 PM, MaRCeLO PeReiRA wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
--------------------
Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
