date format in SQL query

From: <nmadson_at_my-deja.com>
Date: Tue, 30 Nov 1999 23:21:52 GMT
Message-ID: <821m66$80l$1@nnrp1.deja.com>

I got the following query to work, but I wonder if there isn't an easier way? In MS Access I would be able to just say 'BETWEEN #10/1/99# and #10/30/99#'. Is there some sort of comparable syntax in Oracle?

select a.SOURCE_AU, Count(a.DEPOSIT_UISN) as NumDeposits from T_DW_SOW_DEPOSITS a
where a.PROCESS_DATE
between
TRUNC(TO_DATE('10011999', 'MMDDYYYY')) and TRUNC(TO_DATE ('10301999', 'MMDDYYYY'))
group by a.SOURCE_AU

TIA,
Nolan Madson

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 17:21:52 CST