Rudi, select to_char(date_column, 'Month');
See similar under "Formatting Function" in the docs. -- -Josh Berkus ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly