Postgres Pro
Downloads
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
Msg-id B10E6810AC2A2F4EA7550D072CDE876004B2E65D@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: subtract two dates to get the number of days  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: subtract two dates to get the number of days  (Thomas Kellerer <spam_eater@gmx.net>)
Re: subtract two dates to get the number of days  (silly sad <sad@bankir.ru>)
Re: subtract two dates to get the number of days  (Jean-David Beyer <jeandavid8@verizon.net>)
List pgsql-sql
Tree view 
<div class="WordSection1"><p class="MsoNormal">I want to subtract to dates to know the number of days different.<p
class="MsoNormal"> <pclass="MsoNormal">Example:<p class="MsoNormal">01/02/2010 - 01/01/2010 = 1 day<p
class="MsoNormal">08/01/2010- 07/31/2010 = 1 day<p class="MsoNormal"> <p class="MsoNormal">How do I do this? <p
class="MsoNormal"> <pclass="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal">Lance Campbell<p
class="MsoNormal">SoftwareArchitect/DBA/Project Manager<p class="MsoNormal">Web Services at Public Affairs<p
class="MsoNormal">217-333-0382<pclass="MsoNormal"> </div>

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How would I store little key-Nr to text lists?
Next
From: Tom Lane
Date:
Subject: Re: subtract two dates to get the number of days