At 06:46 PM 9/03/2004 +0000, you wrote:

>Are there any functions for date manipulation available
>out of the box or i need UDFs?
>
>I need functions to get current date

Context variable CURRENT_DATE (also CURRENT_TIMESTAMP if you need the time
as well)

>, calculate years difference
>between two dates.

(EXTRACT(YEAR FROM DateX)) - (EXTRACT(YEAR FROM CURRENT_DATE))

Look up the internal EXTRACT() function in the Language Reference.

>Any links to UDFs are greatly appreciated.

Not required.

/heLen