> I need to do some ageing calculations on finance transactions, and
> have got several questions:
>
> A: How can I calculate the dateparts of a date (day, month, year). I

Heve you been tested the "EXTRACT" command??
try it:

SELECT EXTRACT( MONTH FROM <table.date_field> AS MONTH_OF_DATE FROM <TABLE>





[Non-text portions of this message have been removed]