registerdate month value

[searain]

Say in my table, I have a registerdate (date type), in my sql i want to select all the records registered in September, what is the select sql statement?

Interbase best. other database statements fine too.

Thanks.

[rrijnders]

How about

$sql = "SELECT * FROM myTable WHERE EXTRACT(MONTH FROM myDateField) = 9";