>
> only last one question,
> how the truncate 9 mons 9 days to only month part ie
> 9 mons ?
>
select date_part('month',age ('10-10-1999'::timestamp ,
'1-1-1999'::timestamp ));
date_part
-----------
9
(1 row)
or
select extract (month from age ('10-10-1999'::timestamp ,
'1-1-1999'::timestamp ));
date_part
-----------
9
(1 row)
Regards, Christoph