Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Bob" <Go1369@Yahoo.Com>
Newsgroups: comp.databases.oracle.misc
Subject: simple query not so simple
Date: 9 Oct 2005 22:42:51 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1128922971.771520.226820@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 202.128.86.242
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1128922976 1845 127.0.0.1 (10 Oct 2005 05:42:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 10 Oct 2005 05:42:56 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=202.128.86.242;
   posting-account=Vbx1BQwAAABwIjENTeQUtGY4jZBFtNml
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:122538

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?