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






--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to