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
"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
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';
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