Date type select

Hi all,

I'm having a problem to make a select statement with a date type field.

I have a table with a field named date_in and this field is a date type.
Well, I need to do a select where the month is 09 and the year is 1999.
I tried:

SELECT * FROM calls WHERE date_in LIKE '09%1999' ORDER BY date_in

or

SELECT * FROM calls WHERE date_in LIKE '09-__-1999' ORDER BY date_in

or

SELECT * FROM calls WHERE date_in LIKE '09%' AND date_in LIKE '%1999'
ORDER BY date_in

using psql command and I received the following message:

ERROR: There is more than one possible operator '~~' for types 'date'
and 'unknown'
You will have to retype this query using an explicit cast

Could anybody help me ?

Thanks in advance,
Paulo Kappke
Cyclades Brazil