Thread: Age in days

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

This will give you the no of days.
select current_date - dateofbirth::date from people;




--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.

On Sep 10, 2005, at 1:04 AM, Mark A. Strivens wrote:

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

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

Try

select current_date - dateofbirth from people;

Michael Glaesemann
grzm myrealbox com