At 09:39 PM 24/04/2006, you wrote:

>Hi,
>
>Sorry if my question is pretty elementary, but how do I extract date
>parts from a date field. I mean parts like the month, year, etc from a date.

You almost have the syntax right there in your question!

EXTRACT (MONTH FROM mydate)

or DAY, YEAR..

./heLen