Home > mailing lists

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

From	Campbell, Lance
Subject	subtract two dates to get the number of days
Date	July 13, 2010 11:59:03
Msg-id	B10E6810AC2A2F4EA7550D072CDE876004B2E65D@SAB-FENWICK.sab.uiuc.edu Whole thread Raw
Responses	Re: subtract two dates to get the number of days Re: subtract two dates to get the number of days Re: subtract two dates to get the number of days Re: subtract two dates to get the number of days
List	pgsql-sql

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

From: Pavel Stehule
Date: 10 July 2010, 06:02:53
Subject: Re: How would I store little key-Nr to text lists?

From: Tom Lane
Date: 13 July 2010, 12:02:28
Subject: Re: subtract two dates to get the number of days