Re: 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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings