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
grz
This will give you the no of days.select current_date - dateofbirth::date from people;
On 9/9/05, Mark A. Strivens <[EMAIL PROTECTED]> wrote:
If you need to know the age to the nearest day on the present dayI think you can use something like:select date_trunc('day',age(now(),dateofbirth)) from peop
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?
