Received: from chi-mx.truenorth.com (interlock.truenorth.com [199.221.98.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA06802 for ; Wed, 22 Sep 1999 13:53:47 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: from cpsmail.cpsgroup.com (cpsmail.cpsgroup.com [144.210.12.10]) by chi-mx.truenorth.com (8.9.3/8.9.3) with ESMTP id MAA18523; Wed, 22 Sep 1999 12:53:22 -0500 (CDT) Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Wed, 22 Sep 1999 12:52:37 -0500 Message-ID: From: "Jackson, DeJuan" To: Paulo Roberto Kappke , "Jackson, DeJuan" Cc: pgsql-sql@postgreSQL.org Subject: RE: [SQL] Date type select Date: Wed, 22 Sep 1999 12:52:32 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain I think you misunderstood, try: SELECT * FROM calls WHERE date_trunc('month', date_in)='9/1/1999' ORDER BY employee_nbr, date_in; 'date_trunc' is the function not my field name. Your method works well for date but might not for daytime's because of the hour:minutes:seconds specification, but that's another discussion. DEJ > -----Original Message----- > From: Paulo Roberto Kappke [SMTP:paulok@cyclades.com.br] > Sent: Wednesday, September 22, 1999 12:48 PM > To: Jackson, DeJuan > Cc: pgsql-sql@postgreSQL.org > Subject: Re: [SQL] Date type select > > OK DeJuan, but, probably your field's type is datetime and my type is > date. If I use your statement, I receive the following message: > > ERROR: No such function 'date_in' with the specified attributes > > By the way, I'm using the statement: > > SELECT * FROM calls WHERE date_in>='$month-01-$year' AND > date_in<='$month-31-$year' ORDER BY employee_nbr, date_in > > And it works fine. > > Thanks, > Paulo K > > "Jackson, DeJuan" wrote: > > > > template1=> select date_trunc('month', now()); > > date_trunc > > ---------------------------- > > Wed Sep 01 00:00:00 1999 CDT > > (1 row) > > > > template1=> select date_trunc('month', now()) = '9/1/1999'; > > ?column? > > -------- > > t > > (1 row) > > > > Enjoy, > > DEJ > > > > > -----Original Message----- > > > From: Paulo Roberto Kappke [SMTP:paulok@cyclades.com.br] > > > Sent: Wednesday, September 22, 1999 8:13 AM > > > To: pgsql-sql@postgreSQL.org > > > Subject: [SQL] 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 > > > > > > ************