Re: [SQL] Date type select
От | Paulo Roberto Kappke |
---|---|
Тема | Re: [SQL] Date type select |
Дата | |
Msg-id | 37E9163D.BF9C9712@cyclades.com.br обсуждение исходный текст |
Ответ на | RE: [SQL] Date type select ("Jackson, DeJuan" <djackson@cpsgroup.com>) |
Список | pgsql-sql |
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 > > > > ************
В списке pgsql-sql по дате отправления: