Getting number of days

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Getting number of days
Date: 2000-09-27 19:09:16
Message-ID: 20000927190916.27309.qmail@web801.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

Does anybody know how to convert an interval into a
number of days. Say I have something like '2 years 4
months 4 ago', I need to get the total number of days,
something like 800 (ish). Is there a built in
function?

Thanks
W

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-09-27 19:55:40 Re: copying/moving from one table to another
Previous Message Joachim Trinkwitz 2000-09-27 18:24:46 copying/moving from one table to another