[SQL] subtract two dates to get the number of days

I want to subtract to dates to know the number of days different. Example: 01/02/2010 - 01/01/2010 = 1 day 08/01/2010 - 07/31/2010 = 1 day How do I do this? Thanks, Lance Campbell Software Architect/DBA/Project Manager Web Services at Public Affairs 217-333-0382

Re: [SQL] subtract two dates to get the number of days

"Campbell, Lance" writes: > I want to subtract to dates to know the number of days different. > Example: > 01/02/2010 - 01/01/2010 = 1 day > 08/01/2010 - 07/31/2010 = 1 day > How do I do this? If they're dates, you just subtract. regression=# select '08/01/2010'::date - '07/31/2010'::date; ?co

Re: [SQL] subtract two dates to get the number of days

Campbell, Lance, 13.07.2010 16:58: I want to subtract to dates to know the number of days different. Example: 01/02/2010 - 01/01/2010 = 1 day 08/01/2010 - 07/31/2010 = 1 day How do I do this? SELECT DATE '2010-02-01' - DATE '2010-01-01'; SELECT DATE '2010-08-01' - DATE '2010-07-31';

Re: [SQL] subtract two dates to get the number of days

On 07/13/10 18:58, Campbell, Lance wrote: I want to subtract to dates to know the number of days different. it would be far more interesting operation if u want to divide an INTERVAL by INTERVAL to get a ratio :-) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes