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