Age in days - Mailing list pgsql-sql

From Mark A. Strivens
Subject Age in days
Date
Msg-id 200509091104.45412.strivens@bcm.edu
Whole thread Raw
Responses Re: Age in days
Re: Age in days
List pgsql-sql
If you need to know the age to the nearest day on the present day
I think you can use something like:

select date_trunc('day',age(now(),dateofbirth)) from people

gives: 

3 years 2 mons 12 days

My questions is, is there any way to convert that figure into an age
expressed as a number days only?

Many thanks

Mark



pgsql-sql by date:

Previous
From: "Bjoern A. Zeeb"
Date:
Subject: user defined type, plpgsql function and NULL
Next
From: tgoodair@ca.afilias.info (Tim Goodaire)
Date:
Subject: Re: Performance issue