Re: simple query not so simple

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 10 Oct 2005 08:10:56 +0200
Message-ID: <434a05ed$0$3536$626a14ce@news.free.fr>

"Bob" <Go1369_at_Yahoo.Com> a écrit dans le message de news: 1128922971.771520.226820_at_g43g2000cwa.googlegroups.com...
| SQL=
|
| select count(*),sum(atp_amount) from fdsmastrep where trans_month =
| 10/1/2004
|
| the trans_month field is a date field and I need to get the records for
| the year beginning 10/1/2004 and ending 9/30/2005
|
| I get an "inconsistent data types" error.
|
| can somebody help me out?
|

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions137a.htm#1003595 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/conditions6a.htm

Regards
Michel Cadot Received on Mon Oct 10 2005 - 01:10:56 CDT