Re: [SQL] Date type select - Mailing list pgsql-sql
From | Paulo Roberto Kappke |
---|---|
Subject | Re: [SQL] Date type select |
Date | |
Msg-id | 37EA1AF6.FDA1A893@cyclades.com.br Whole thread Raw |
In response to | RE: [SQL] Date type select ("Jackson, DeJuan" <djackson@cpsgroup.com>) |
List | pgsql-sql |
Yes, I made a big confusion. The statement that you sent and George worked fine too. Thanks, Paulo K "Jackson, DeJuan" wrote: > > 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 > > > > > > > > ************ -- _______________________________________________ Paulo Roberto Kappke Web System Developer voice: 55-11-5090-3341 fax:55-11-5090-3388 Cyclades Corporation - http://www.cyclades.com Cyclades Brasil - http://www.cyclades.com.br _______________________________________________