Received: from cyclades.com.br (nicole-kidman.cyclades.com.br [200.246.93.9]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA54134 for ; Wed, 22 Sep 1999 09:10:49 -0400 (EDT) (envelope-from paulok@cyclades.com.br) Received: from cyclades.com.br (danielle-winits.cyclades.com.br [200.246.93.41]) by cyclades.com.br (8.8.8/8.8.3) with ESMTP id KAA21929 for ; Wed, 22 Sep 1999 10:19:38 -0300 Message-ID: <37E8D5C8.B1B97489@cyclades.com.br> Date: Wed, 22 Sep 1999 10:12:40 -0300 From: Paulo Roberto Kappke Organization: Cyclades Brasil X-Mailer: Mozilla 4.61 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Date type select References: <37E7FF29.1BB059BC@unacs.bg> <37E8CBDE.B87F1653@sferacarta.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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