Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date format in SQL query
Hi,
Try BETWEEN '01-OCT-99' and '30-OCT-99'
This will depend on your default date format.
HTH. Wesley.
In article <821m66$80l$1_at_nnrp1.deja.com>,
nmadson_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 30 1999 - 21:05:15 CST
![]() |
![]() |