Postgres Pro
Downloads
Home   >   mailing lists

Re: subtract two dates to get the number of days - Mailing list pgsql-sql

From Tom Lane
Subject Re: subtract two dates to get the number of days
Date
Msg-id 29026.1279033330@sss.pgh.pa.us
Whole thread Raw
In response to subtract two dates to get the number of days  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-sql
Tree view 
"Campbell, Lance" <lance@illinois.edu> 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;?column? 
----------       1
(1 row)

        regards, tom lane

pgsql-sql by date:

Previous
From: "Campbell, Lance"
Date:
Subject: subtract two dates to get the number of days
Next
From: Thomas Kellerer
Date:
Subject: Re: subtract two dates to get the number of days