Select stmt question on date

I would like to select all rows from my database where my_date's day is not '01'.

This are samples what I what I want
-----------------------------------
1994-11-14
2001-01-10


This are samples what I don't want
-----------------------------------
2002-02-01
2002-01-01
1998-12-01

How can I make the query? Currently I am using 'NOT LIKE '%-01'' and I find that this query is very slow.

Any alternative on this?

Many thanks

Use the EXTRACT functions described at http://www.postgresql.org/idocs/ind...s-datetime.html