Days betwen dates

From: Andy Holman <info(at)i-developit(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Days betwen dates
Date: 2001-01-09 16:18:44
Message-ID: 3A5B39E4.2D1346C0@i-developit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Anyone know how I can just get the number of
days between dates in 2 columns in a query?

I am using something like age('dateone', 'now')
currently but that returns 1 year 10 mons 14 12:53:10
or something of the like. I just want the days between
them. I am using php. Please let me know if you have
any ideas.

Thanks,
Andy

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-09 17:05:16 Re: Re: Advice on stored proc error handling versus Sybase?
Previous Message Ken Corey 2001-01-09 12:01:02 Re: Advice on stored proc error handling versus Sybase?