Subtraction of Dates

From: "Valerie Goodman" <VGoodman(at)aih(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Subtraction of Dates
Date: 2002-06-27 13:21:36
Message-ID: NEBBIJFAKLBIBECFEAGOCEEHCPAA.VGoodman@aih.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


When I want an integer for a number of days between two dates, direct
subtraction of two dates returns an integer.

However, age function returns an interval.

Which is the correct method to use and if age is the correct method, how do
I convert that to the number of days?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-06-27 13:44:13 Re: CHECK clause doesn't work with CASE clause
Previous Message q u a d r a 2002-06-27 11:50:09 graphical interface - admin