Searching between Dates
From: Andy Konopka <andy.konopka_at_camtronics.com>
Date: Wed, 21 Feb 2001 14:01:26 -0600
Message-ID: <p6Vk6.2975$7e6.1244473_at_homer.alpha.net>
GROUP BY TRUNC(PLAN_S_DATE); Received on Wed Feb 21 2001 - 21:01:26 CET
Date: Wed, 21 Feb 2001 14:01:26 -0600
Message-ID: <p6Vk6.2975$7e6.1244473_at_homer.alpha.net>
I was wondering if someone could explain why I receive a error when I run
the following query,
SELECT TRUNC(PLAN_S_DATE) as CallDate, Count(PLAN_S_DATE) AS TotalCalls
it works using ACCESS 2000 but not in Oracle
FROM ACTIVE_SEPARATE WHERE PLAN_S_DATE BETWEEN (&PLAN_S_DATE_START AND &PLAN_S_DATE_END) AND (((ORG_CODE='613') OR (ORG_CODE='614') OR (ORG_CODE='618')))
GROUP BY TRUNC(PLAN_S_DATE); Received on Wed Feb 21 2001 - 21:01:26 CET