Subtraction of Dates - Mailing list pgsql-sql

From Valerie Goodman
Subject Subtraction of Dates
Date
Msg-id NEBBIJFAKLBIBECFEAGOCEEHCPAA.VGoodman@aih.co.uk
Whole thread Raw
List 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?






pgsql-sql by date:

Previous
From: Jeff Boes
Date:
Subject: Re: to_char() and order-by
Next
From: Dennis Kaarsemaker
Date:
Subject: Re: Calculating with sql